June 14, 2017 at 11:34 am
I Have a package where in the source I am using the query , in this query there is a column called enddate and datatype is date,null
in the target table I have created same column called enddate date,null
I brought source and destination componenets and configured the table.
I received error in the log file called
Description: The external columns for OLE-DST- Target Table are out of synchronization with the data source columns.
-- The external column "EndDt" needs to be updated.
I checked the package by going to advanced editor and checked external columns the enddt is showing as unicode string dt_wstr. i tried to update it dt_dbbate but still its comming as Unicode string
From the source its giving as dt_dbbate the problem is the destination component external column not sure why it is showing as Unicode?
Any inputs ..
June 14, 2017 at 1:18 pm
SSIS can be fussy sometimes.
I'd load the package up in visual studio and try to recompile it with the data source pointing to the same one as your live. If it compiles successfully, re-deploy it to the SSIS server.
If it gives you any errors or warnings, look at the object that is giving the error/warning and open it up and double check all of the mappings and hit OK and try to recompile again.
If it still is unhappy, you may need to rebuild it from scratch.
I've had to rebuild some that failed to properly get the metadata from the server and kept complaining like that. Mine were pretty simple to rebuild thankfully.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply