Why am I getting these errors for my Flat File Source? TITLE: Package Validation Error------------------------------ Package Validation Error ------------------------------ADDITIONAL INFORMATION: Error at Data Flow Task [DTS.Pipeline]: input column "Column 23" (3893) has lineage ID 8828 that was not previously used in the Data Flow task. Error at Data Flow Task [DTS.Pipeline]: "component "EBN_TEMP1" (528)" failed validation and returned validation status "VS_NEEDSNEWMETADATA". Error at Data Flow Task [DTS.Pipeline]: One or more component failed validation. Error at Data Flow Task: There were errors during task validation. (Microsoft.DataTransformationServices.VsIntegration) ------------------------------BUTTONS: OK------------------------------

remap the fields

remap the fields

This happens when there is a change in the SQL server Schema design and your meta data in SSIS package becomes outdated. You can open the Data Source in your Data Flow Task and save it without any manual changes. Editor will report the issue if there is any and you can update the source appropriately and consequently the transformation as well. IF the problem persists then you might have to remap the the source fields just as Amal suggested Please mark the post as answered if it answers your question