Deploy Projects to Integration Services Server

  • Article

In the current release of Integration Services, you can deploy your projects to the Integration Services server. The Integration Services server enables you to manage packages, run packages, and configure runtime values for packages by using environments.

For more information about environments, see Create a Server Environment.

Note

As in earlier versions of Integration Services, in the current release you can also deploy your packages to an instance of SQL Server and use Integration Services service to run and manage the packages. You use the package deployment model. For more information, see Package Deployment (SSIS).

To deploy a project to the Integration Services server, complete the following tasks:

  1. Create an SSISDB catalog, if you haven’t already. For more information, see Create the SSISDB Catalog.

  2. Convert the project to the project deployment model by running the Integration Services Project Conversion Wizard . For more information, see the instructions below: To convert a project to the project deployment model

    • If you created the project in SQL Server 2012 Integration Services (SSIS), by default the project uses the project deployment model.

    • If you created the project in an earlier release of Integration Services, after you open the project file in Visual Studio, convert the project to the project deployment model.

      Note

      If the project contains one or more datasources, the datasources are removed when the project conversion is completed. To create a connection to a data source that the packages in the project can share, add a connection manager at the project level. For more information, see Add, Delete, or Share a Connection Manager in a Package.

      Depending on whether you run the Integration Services Project Conversion Wizard from Visual Studio or from SQL Server Management Studio, the wizard performs different conversion tasks.

      • If you run the wizard from Visual Studio, the packages contained in the project are converted from Integration Services 2005, 2008, or 2008 R2 to the format that is used by the current version of Integration Services. The original project (.dtproj) and package (.dtsx) files are upgraded.

      • If you run the wizard from SQL Server Management Studio, the wizard generates a project deployment file (.ispac) from the packages and configurations contained in the project. The original package (.dtsx) files are not upgraded.

        You can select an existing file or create a new file, in the Selection Destination page of the wizard.

        To upgrade package files when a project is converted, run the Integration Services Project Conversion Wizard from Visual Studio. To upgrade package files separately from a project conversion, run the Integration Services Project Conversion Wizard from SQL Server Management Studio and then run the SSIS Package Upgrade Wizard. If you upgrade the package files separately, ensure that you save the changes. Otherwise, when you convert the project to the project deployment model, any unsaved changes to the package are not converted.

    For more information on package upgrade, see Upgrade Integration Services Packages and Upgrade Integration Services Packages Using the SSIS Package Upgrade Wizard.

  3. Deploy the project to the Integration Services server. For more information, see the instructions below: To deploy a project to the Integration Services server.

  4. (Optional) Create an environment for the deployed project. For more information, see Create a Server Environment.

To convert a project to the project deployment model

  1. Open the project in Visual Studio, and then in Solution Explorer, right-click the project and click Convert to Project Deployment Model.

    -or-

    From Object Explorer in Management Studio, right-click the Projects node and select Import Packages.

  2. Complete the wizard. For more information, see Integration Services Project Conversion Wizard.

To deploy a project to the Integration Services Server

  1. Open the project in Visual Studio, and then From the Project menu, select Deploy to launch the Integration Services Deployment Wizard.

    -or-

    In SQL Server Management Studio, expand the Integration Services > SSISDB node in Object Explorer, and locate the Projects folder for the project you want to deploy. Right-click the Projects folder, and then click Deploy Project.

    -or-

    From the command prompt, run isdeploymentwizard.exe from %ProgramFiles%\Microsoft SQL Server\110\DTS\Binn. On 64-bit computers, there is also a 32-bit version of the tool in %ProgramFiles(x86)%\Microsoft SQL Server\100\DTS\Binn.

  2. On the Select Source page, click Project deployment file to select the deployment file for the project.

    -OR-

    Click Integration Services catalog to select a project that has already been deployed to the SSISDB catalog.

  3. Complete the wizard. For more information, see Integration Services Deployment Wizard.