External metadata column error

  • I keep getting the following error in SSIS. Also, I don't get the error on every server the package is run on, but less than 5 (the package is run on over 100).

    "The external metadata column collection is out of synchronization with the data source columns. The column "Timestamp" needs to be added to the external metadata column collection"

    Please tell me where I need to remove Timestamp from. Thanks

    -Kyle

  • Hi,

    No need to worry,

    It is basically data type related. This genarlly happens when the source column datatypesize and target table datatype size are not matching.

    Simply what u do is ,

    Dblclick the data flow.

    On the select the Src Connection -->right click --> Show in Advance Editor--> Go to Input and Output Columns and expand the External and Output column nodes and check the sizes of the columns. They should be matching. The same need to be done on Target OLEDB connection.

    Ensure that source columns and trg columns are in sync. If this done, u wont get these Metadata sync Errors.

    Regards,

    Mahesh

  • Thank you very much.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply