Deployment Through the SSIS Deployment Wizard
You have generated your SQL Server Integration Services (SSIS) assets, and are ready to deploy. This document will discuss deployment using the SSIS Deployment Wizard to deploy the SSIS projects that were generated by BimlFlex. For information on how to deploy using the PowerShell, review our Deployment Through PowerShell.
Launching the Wizard
In order to use the Deployment Wizard, the user must first locate and launch it. In order to do so, the user has two options.
- Look up the term SQL Server Deployment Wizard in the Windows Search.
- Locate the file named ISDeploymentWizard.exe under the SQL Server installation folder; for example:
C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn.
Steps for Deployment
After launching the wizard, follow these steps.
Select the Integration Services project that you wish to deploy. Click the Browse button and locate the .ispac file that corresponds to the project that you wish to deploy. The desired .ispac file will be located in a path similar to the one listed below. [ProjectName] corresponds to the name of the project that you wish to deploy.
Enter the destination server name and the folder that will house the project in the Integration Services catalog. Simply browse and select your desired server and then Browse and select your desired SSIS Folder. This value should typically be the same as your SSIS Folder value in your BimlFlex settings.
The user must ensure that the SSIS catalog exists on the destination server.
Review and Deploy. Ensure that everything has been set up correctly and then click Deploy.
Observe that the project has successfully deployed. Once the project has been deployed, the user should deploy the next project in solution.