August 15, 2007 at 9:23 am
I am running an SSIS package and I keep getting this error when it gets to a the dataflow task. I have a bit of an idea of what it means, but I can't figure out how to fix it. IF anybody could explain this error and fixes for it that would be of immense help. Thank you.
Error: 0xC004701C at Load Server Security, DTS.Pipeline: input column "Server" (1434) has lineage ID 1421 that was not previously used in the Data Flow task.
Error: 0xC004706B at Load Server Security, DTS.Pipeline: "component "OLE DB Destination 1" (1420)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".
Error: 0xC004700C at Load Server Security, DTS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Load Server Security: There were errors during task validation.
August 16, 2007 at 4:26 am
The metadata for the "Server" source has changed. Looks like a change to the datatype has happened at source. edit the oledb source and check the column mappings. You may get warnings on any transformations in the downstram pipeline. you need to edit the transformations and correct them. It will prompt you to automattically fix them which ssis seems to do in most cases.
PS. You should see a yellow exclamation on the component that has failed the validation in the data task.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply