flat file archived orders report returned no data

Next connect your flat file source connection to the sql server destination connection with the green arrow.Ĭonfigure your SQL Server destination. Under Preview - take another look and make sure everything looks correct Under Advanced - You can now select each column and choose the data type and precision (these should ideally match your SQL Server table) Now you should hopefully see your data in rows and columns that make sense. Select the Reset Columns button and this will allow you to change the column delimiter (which will likely be tab or space) and click Refresh. Another question, now is all your data in one column or is it in multiple columns? If it is all in one column your delimiter is not set up correctly. Under Columns - This will give you a rough view of the columns and data (if you don't have the column checked in the step before you will see Column 0, like your error, if it is checked you will see your headers). Under General - Make sure first row has Column Name in the First Data Row is checked (assuming your first row is headers) Here are a couple things to look at in the meantime:Īs you configure the flat file connection manager in the editor there are four categories down the left side. Do you know if it is tab-delimited or space delimited (not common, but this is what it looks like the way it is pasted in)? Question: the data you provided appears to be a delimited file. Configuring the data sources may be where the issue lies. Then open the data flow task and add the flat file source and SQL Server destination. The most direct way to extract data from a flat file into SQL Server 2005 using SSIS is to add a data flow task to the control flow.

Flat file archived orders report returned no data