Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS 2012 what are main differences with SSIS 2008 R2 ??? Expand / Collapse
Author
Message
Posted Wednesday, December 12, 2012 3:43 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 7:53 AM
Points: 78, Visits: 160
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.
Post #1395908
Posted Thursday, December 13, 2012 1:13 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:45 AM
Points: 13,538, Visits: 10,412
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)




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1396038
Posted Thursday, December 13, 2012 9:31 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 7:53 AM
Points: 78, Visits: 160
Thanks a lot for your kind reply.

Have a good day.
Post #1396255
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse