Error in SSIS package while import from MS SQL to MYSQL

Question

I am working on creating a SSIS package to import data from MSSQL to MYSQL. I am getting the following error while executing.

[ADO NET Destination [16]] Error: The external column "<columnname>" (145) has been out of synchronization with the database column. The latest column has new length: 382 . Use advanced editor to refresh  available destination columns if needed.

[SSIS.Pipeline] Error: "component "ADO NET Destination" (16)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".

columnname == "lastname"
datatype of "lastname"
MSSQL - nvarchar(255)
MYSQL - varchar(255)

Thank you

TTeeple TTeeple · Accepted Answer · 2014-02-03T18:50:47

Sounds like there might have been a database change on one of the tables. You might need to refresh the metadata on the source/destination.

Error in SSIS package while import from MS SQL to MYSQL

2 Answers