August 20, 2012 at 7:41 am
In the advanced editor for the OLE DB Destination I am adding columns to "External Columns". Once they are added I mapp the input column to the destination column and click 'OK'.
Then I get the below error message for the three columns I added. I select 'NO' to correct the error automatically and when I go back to the advanced editor the columns are no longer there.
The new columns are already in the flat file source and the destination table. How do I get the new columns to syncranize and remain?
[OLE DB Destination [21]] Warning: The external columns for component "OLE DB Destination" (21) are out of synchronization with the data source columns. The external column "NUMBER_OF_PAYMENT_EXPERIENCES_SLOW180PLUS" (18940) needs to be removed from the external columns.
The external column "EB_FILE_NB" (18939) needs to be removed from the external columns.
The external column "EB_HIT_NOHIT" (18938) needs to be removed from the external columns.
August 20, 2012 at 7:58 am
This was removed by the editor as SPAM
August 20, 2012 at 3:01 pm
You were right. I had to change the way the table was being created in the first phase of the data flow. Thanks!
August 23, 2012 at 7:05 am
Now I need to change the data type of one of the destination (external)columns in the advanced editor but every time I change it it goes back to the original data type. The data type of the column on the table is correct but i can't seem to save the change in the ssis package. Any Ideas?
August 23, 2012 at 7:09 am
This was removed by the editor as SPAM
August 27, 2012 at 3:33 pm
Will do thanks.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply