CODEWITHSUNDEEP
sql-servervisual-studio-2012ssisssis-2012
Melanie
Melanie

Reputation: 3111

Converting to SSIS 2012 Project Deployment Model

I'm converting our 2008 SSIS packages to 2012 and I want to use the project deployment model. I opened the SSIS packages in Visual Studio 2012 and had no issues converting them to 2012. I chose the simplest package and right-clicked and picked Convert to Package Deployment Model. I went through the wizard and checked "Remove configurations from all packages after conversion" on the Select Configurations screen. Again, I got no errors. I then built the package and sent the resulting files to our DBA for deployment. When he deploys, he tells me that he still sees the old project configurations (they're the two SSISConfig Connection Managers):

enter image description here

He says this shouldn't be. What am I doing wrong?

Upvotes: 0

Views: 402

Answers (1)

billinkc
billinkc

Reputation: 61211

Because the packages have those connection managers in them, they will show up on this screen. That doesn't mean they are being used though. If they were only ever used for getting your configurations, they should be unused now but the wizard won't actually delete them.

In your two packages, delete the SSISConfig connection managers manually and the above screen should no longer report them.

Upvotes: 1

Related Questions