SQL Server Performance

SQL Package Validation Error

Discussion in 'ALL SQL SERVER QUESTIONS' started by immyjay, Aug 7, 2012.

  1. immyjay New Member

    Hi, I'm new to SQL and I'm having this issue with a SSIS package I'm trying to execute. The package was set up for me, so I don't know how to fix it. Basically, I have 4 files (one of which is in the message below: pl_a_refurbished) that go through the package and it comes out with new data (old data is in the database that we use), but when I try to execute it, this error message comes up:

    Error at pl_a_refurbished [DTS.Pipeline]: input column "" (180) has lineage ID 118 that was not previously used in the Data Flow task.

    Error at pl_a_refurbished [DTS.Pipeline]: "component "OLE DB Destination" (14)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".

    Error at pl_a_refurbished [DTS.Pipeline]: One or more component failed validation.

    Error at pl_a_refurbished: There were errors during task validation.

    (Microsoft.DataTransformationServices.VsIntegration)

    If anyone knows how to help, that would be most appreciated.

    Thanks
  2. Shehap MVP, MCTS, MCITP SQL Server

    Fundamentally , such SSIS package errors have nothing to do with integration service itself , but with the design of SSIS package itself in particular more the column mapping since it sounds like some column names or columns data type are changed at either source or destination ….

    I do recommend to review it back and make sure that all columns of source + destination are mapped well

    Kindly work out it and let me know if any further help is needed

Share This Page