Notifications
Clear all

[Solved] Input columns has lineage ID that was not previously used in data flow task

 

Joined: 1 year ago
Posts: 2
Topic starter  

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)

------------------------------

 

 


Quote
Joined: 1 year ago
Posts: 2
Topic starter  

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.

 

This post was modified 1 month ago by s21s101
This post was modified 1 month ago 4 times by plehmann

ReplyQuote
Share: