Why are the columns off in my SSIS output table?
This is what the SSIS package does: - Pulls file from FTP - LOOPS - Parse Data (Fixed width) - Stores data to database. It had been running fine but now the issue i have been facing is that, for instance, data that was supposed to be added to column A is now added to column M (this is an example), I know, if it could start adding data from column A, everything would be fixed. Could somebody please explain me why this happened and how can I fix it? Thank you,
November 8th, 2012 4:10pm
Hi Techmaraduar, Welcome to the MSDN Forum. For SSIS issue, please ask it here: http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/threads Thank you for your understanding and support. Best regards,Mike Feng MSDN Community Support | Feedback to us Please remember to mark the replies as answers if they help and unmark them if they provide no help.
November 9th, 2012 9:10am
Hi techmaraduar, Please open the flat file connection manager, and click "Columns" tab to preview the data and re-configure the connection mananger accordingly, for more information about the flat file connection manager, please see: http://msdn.microsoft.com/en-us/library/ms140266.aspx If the issue still persists, please supply more information about the issue, such as how do you configure each component in the package. Thanks, EileenEileen Zhao TechNet Community Support
November 14th, 2012 10:28pm