February 17, 2015 at 11:44 pm
Hello all,
I have a SSIS package that simply moves data from a SQL database A to another SQL database B. I have update (increased) the size of a nvarchar column, on both A and B.
I am wondering if there is a way to "refresh" somehow the SSIS package so I don't have to rebuild and redeploy it.
The error I get now is a truncation error: "Text was truncated or one or more characters had no match in the target code page".
Thank you!
February 18, 2015 at 11:15 am
ASFAIK- you would need to open the ssis package and refresh it for it pick up the metadata changes.
February 18, 2015 at 1:49 pm
Open the source, go to columns and deselect all columns. Select them again.
Go to the destination, open it and click OK.
This should have refreshed all metadata.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply