SSIS 2012 what are main differences with SSIS 2008 R2 ???

  • Hi to all.

    I currently use SSIS 2008 R2.

    I have to change to NEXT VERSION 2012.

    I have a lot of SSIS Tasks written with SSIS 2008 R2 version.

    My question is there anyone that did that conversion ???

    What are the main differences ???

    Are there any bad problems to do with mthis kind of conversion ????

    Anywhere is there good documentation about that ????

    Many thanks to all.

  • It depends.

    In SSIS 2012 you have two ways of developing your packages:

    * using the project deployment model (brand new and too much to explain in a forum post)

    * using the package deployment model (same as in SSIS 2008, also known as legacy deployment model)

    If you choose to go with the project deployment model, you'll have to do a lot of changes (no more package configurations for example), but there's an upgrade wizard. This deployment model is however - in my opinion - much better than the other one.

    If you choose to stick with the package deployment model, you'll probably don't have to change much. (maybe update the script tasks/components, haven't tried that myself)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Thanks a lot for your kind reply.

    Have a good day.

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

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