question

pvsrinivasrao avatar image
pvsrinivasrao asked

SSIS: External columns for a component "" are out of synchronization with the data source columns

External columns for a component "abcd source" are out of synchronization with the data source columns. The column "col1" needs to be added to the external columns. The external column "col1 " (680) needs to be removed from the external columns. [SSIS.Pipeline] Error: "component "abcd source" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA". I have a Data flow task in SSIS package. Source: (2005 server) Select col1 from abcd; Destination: (2008 server) abcd table. Mapping: By column name. Don't know why i am gettig above mentioned error, tried to resolve by refreshing the mapping couple of times but not of major use. please let me know your suggestions on this. Thanks.
sql-server-2008sql-server-2005ssisupgrade
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.