The external metadata column collection is out of synchronization with the data source columns.

One of my SQL Job failed with Error and the failure was due to an issue with SSIS Package.

There are multiple reasons when this error occurs but I just share the approach and one of the examples:

Do you want the component to fix these errors automatically?
When you try to open impacted component you will receive an error and you will be asked if you want to allow this error to be fixed automatically. Press Yes… This will fix the problem in most of the scenarios.

Edit the Source and check what the columns your SQL Command is pulling are. It is possible that few or all of the columns are missing resulting this error. I recommend to execute the same command on SSMS and check if it returns expected columns or not.

This entry was posted in SQL, SQL Error, SSIS and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s