Post reply

Handling datatype changes after deployment SSIS

  • October 10, 2012 at 1:16 am

    #147431

    Hi All,

    I have created a ssis project and deployed it to the server. And after the deployment has been done, some of the datatypes of the table columns are to be changed. If i change the datatypes there could be some metadata mismatch in the package. So how can i fix this without going into the package.

    Thanks in advance.... 🙂

  • October 11, 2012 at 4:36 am

    #1547990

    You will need to go to the package to update the metadata. Otherwise you will get validation errors.

  • October 12, 2012 at 2:29 am

    #1548487

    Agree. cant think of any way round it.

    Ian Cockcroft
    MCITP BI Specialist

Viewing 3 posts - 1 through 2 (of 2 total)

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