Notifications
Clear all
Topic starter
17/05/2022 5:17 pm
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Load Monthly Sales [SSIS.Pipeline]: DataMart.Inputs[OLE DB Destination Input].Columns[LAST_DAY_OF_MONTH_unmapped] has lineage ID 227 that was not previously used in the Data Flow task.
Error at Load Monthly Sales [SSIS.Pipeline]: "DataMart" failed validation and returned validation status "VS_NEEDSNEWMETADATA".
Error at Load Monthly Sales [SSIS.Pipeline]: One or more component failed validation.
Error at Load Monthly Sales: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
Topic starter
17/05/2022 5:27 pm
This error happens, if you have unmapped input and unmapped output columns in your data flow.
Right-Click on the blue line between where the error occurs and select Resolve References.
Assign the unmapped destination column.
Then, it should work.
