SSIS error - has lineage ID 8828 that was not previously used in the Data Flow task - - -VS_NEEDSNEWMETADATA

SSIS error -  has lineage ID 8828 that was not previously used in the Data Flow task - - -VS_NEEDSNEWMETADATA


To resolve the above error

This happens when there is a change in the SQL server Schema design and your meta data in SSIS package becomes outdated or recently any changes has been applied. 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.

Or
If the code is outdated and the dataflow task source or any task content is changed then this error occurs. To resolve this, double click on each of the task that has this error. You should get an option of "Do you fix the metadata....issues automatically..." Click on Yes. Your error should go away.

If your error is still not fixed then recreate each of the tasks and execute it to make the code work. 

The external columns for component "OLE_SRC Get are out of synchronization with the data source columns.

The external columns for component "OLE_SRC Get Transactions" (187) are out of synchronization with the data source columns. The external column "TotalSalesUnits" needs to be updated.
The external column "TotalSalesValue" needs to be updated.


To resolve the above error Set the ValidateExternalMetadata property for the task to False

[OLE DB Destination [761]] Warning: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

[OLE DB Destination [761]] Warning: Cannot retrieve the column code page info from the OLE DB provider.  If the component supports the "DefaultCodePage" property, the code page from that property will be used.  Change the value of the property if the current string code page values are incorrect.  If the component does not support the property, the code page from the component's locale ID will be used.



To resolve this error perform the below steps

1. Double click on the Data flow task

2. Right Click on the OLE DB SOurce data flow task.  

3. Then go to the properties tab and set the AlwaysUseDefaultCodePage peoprty to True.