All geek questions in one place

How can I deploy one package from SQL Server Data Tools to SSIS 2012?

I have several SSIS packages distributed across several projects in SQL Server Data Tools (formerly BIDS) that I want to deploy to the SSIS directory database on my server.

When I want to deploy the entire project, I can simply right-click the project and click Deploy to launch the SSIS Deployment Wizard. However, it seems that there is no way to do this for only one package without redistributing the remaining packages in one project.

Does anyone know if it is possible to deploy only one package using the deployment wizard independently of the others in the project?

+6
source share
3 answers

This is not possible using the Deployment Wizard or SSDT. A similar discussion into this thread ... where the original poster offers a (terribly tame) workaround.

+4
source

You can also get BIDSHelper from Codeplex (a free tool). It contains a utility that allows you to deploy SSIS packages from BIDS. I have not tested BIDS Helper with SSDT yet. You might also want to grab the SSIS package manager from Codeplex.

+1
source

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

  • In SSMS, connect to the Integration Services instance.
  • Right-click the appropriate node (file system or MSDB) and select Import Package .
  • Set the location of the file system package.
  • Click the three dots next to the Package. Go to your SSDT project and select the .dtsx file you want to import.
  • Click OK. If prompted to overwrite the existing package, click Yes.
+1
source

Source: https://habr.com/ru/post/915686/

More articles:


All Articles