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

SSIS can throw a very frustrating error :
The external metadata column collection is out of synchronization with the data source columns. The column “x” needs to be updated in the external metadata column collection.
In such cases, find the step that has failed in the Control Flow tab of the dtsx package (while troubleshooting in BIDS : let me know if you need help doing this). Then rt clk > edit > you get the “Data Flow” page with the Source and Destination boxes.
Rt clk the Source box first > Edit > you should see SSIS pop up a dialog box saying it has found Validation errors and do you want to resolve it. Click YES and take columns. Ensure all the “External Columns” have a matching “Output Column”. Click OK. This resolves the Source part.
Now for the Destination. You should see a tiny red cross on the Destination box. Mouse over it to read that there is a difference here that was not there earlier. We will correct this by rt clk > edit and then clicking OK. A warning icon (in yellow) now appears on the Destination box. Again, rt clk > Edit > YES to get past the dialog box to the Destination Editor. Now here, choose the Mappings tab on the left. You will find that one or more columns in the “Input Column” do not have a corresponding “Destination Column”. Click the missing input column (marked with antext) to display a drop down button. You will find your missing column in the drop down. This will complete the sync issue that is displayed in your SSIS package.
Save everything and re-run the troubleshooter. You should be good this time.
NB : Depending upon the number of steps involved in your SSIS package, you may have to repeat this process for each step.
As always, do post your comments / corrections. Good luck with your SSIS !

Advertisements
This entry was posted in Uncategorized and tagged . Bookmark the permalink.

One Response to The external metadata column collection is out of synchronization with the data source.. SSIS error

  1. Andrew says:

    Thanks. Seems somebody changed the fields in one of the databases. Love it when people take the time and provide resolutions to problems to everybody.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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