SQL Server Performance

Package Validation Error

Discussion in 'SQL Server 2005 Integration Services' started by immyjay, Aug 6, 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

Share This Page