SSIS - Updating source and target data structure

  • 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!

  • ASFAIK- you would need to open the ssis package and refresh it for it pick up the metadata changes.

  • 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