Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I deploy a single package from SQL Server Data Tools in SSIS 2012?

I've got a number of SSIS packages spread across multiple projects in SQL Server Data Tools (formerly BIDS), which I want to deploy to the SSIS Catalog DB on my server.

When I want to deploy an entire project, I can just right-click the project and hit Deploy, to start the SSIS deployment wizard. However, there doesn't seem to be an option to do this for a single package only, without redeploying the rest of the packages in the same project.

Does anyone know if it's possible to deploy just a single package using the deployment wizard, independently from the others in the project?

like image 414
GShenanigan Avatar asked May 14 '12 14:05

GShenanigan


2 Answers

This does not appear to be possible via the deployment wizard or SSDT. Similar discussion in this thread...where the original poster proposes a (terribly manual) workaround.

like image 101
Bill Anton Avatar answered Sep 30 '22 20:09

Bill Anton


You might also want to get BIDSHelper from Codeplex (free tool). It contains a utility to allow you to deploy SSIS packages from BIDS. I haven't tested BIDS Helper with SSDT yet. Also you might want to grab SSIS Package Manager from Codeplex as well.

like image 34
Lynn Langit Avatar answered Sep 30 '22 18:09

Lynn Langit