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,

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.

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