CODEWITHSUNDEEP
ssissql-server-2012
GShenanigan
GShenanigan

Reputation: 5493

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?

Upvotes: 6

Views: 8263

Answers (3)

Keith
Keith

Reputation: 21224

You can use SQL Server Management Studio to import a single package:

  1. In SSMS, connect to your Integration Services instance.
  2. Right-click the appropriate node (File System or MSDB) and select Import Package.
  3. Set Package Location to File System.
  4. Click the three dots next to Package Path. Browse to your SSDT project and select the .dtsx file you want to import.
  5. Click OK. If prompted to overwrite the existing package, click Yes.

Upvotes: 1

Lynn Langit
Lynn Langit

Reputation: 4060

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.

Upvotes: 1

Bill Anton
Bill Anton

Reputation: 2970

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.

Upvotes: 4

Related Questions