OLE DB Source Warning/Error regarding "VS_NEEDSNEWMETADATA"

  • I am very new to ssis and need a little help.

    I have a SQL Editor task that runs a sql statement to pull data from an oracle db. I then have a data flow task set up, right after, to import those values into a sql server table. So the process runs as SQL Editor task --> Data Flow. the Data Flow has 3 parts: an OLE DB Source ---> Data Coversion Transformation --> OLE DB Destination.

    I did make a change to the sql code and the errors started:

    I get the following errors: [OLE DB Source [91]] Warning: Truncation may occur due to retrieving data from database column "M_ID" with a length of 50 to data flow column "M_ID" with a length of 20. [OLE DB Source [91]] Warning: Truncation may occur due to retrieving data from database column "LOB" with a length of 52 to data flow column "LOB" with a length of 26. [OLE DB Source [91]] Warning: The external metadata column collection is out of synchronization with the data source columns. The column "M_ID" needs to be updated in the external metadata column collection. The column "language" needs to be added to the external metadata column collection. The column "LOB" needs to be updated in the external metadata column collection. The "external metadata column "LANGUAGE" (199)" needs to be removed from the external metadata column collection.

    I've tried everything I googled and could think of to sync the metadata. I deleted the data flow task and re-created it. I unchecked fields in the OLE DB Source, refreshed both source and destination then re-checked them and refreshed. I delete the connection manager and the data flow task and re-created both and it still errors out. Usually the pop-up to have it automatically fix errors would come up. It does not. I dont know what else to try to sync the source and destination. I added the data conversion to change the fields so that the source and table will have the same lengths but it does not seem to work. Can someone please help or show me where I went worng? I'm at a total lost. Thanks!

Viewing 0 posts

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