The Package Deployment Wizard in BI xPress gives users more options when deploying SSIS packages. Users can deploy multiple packages at once without having to deploy an entire project. A special ‘2 way deployment’ feature allows for copying packages from a target location to a source.
• Deploy multiple packages at once, even from different projects
• Copy XML configuration files to the target location during deployment
• Handles deployment to file system, database, and package store
• Override configurations and connections strings
Package Deployment cannot deploy SSIS packages to the SSIS Package Catalog.
Additionally, Pragmatic Workbench (32-bit) must be used when deploying SSIS packages on a machine that only contains SSDT for Visual Studio 2015.
Table of Contents
Launching the SSIS Deployment Wizard
You can open the SSIS Deployment wizard in three ways: Opening it from Pragmatic workbench, click the Package Deployment icon in the toolbar, or right-click the SSIS project in the BIDS Solution Explorer window and select Deploy SSIS Package. You can also deploy a single SSIS package using the BI xPress Package Deployment Wizard by right-clicking the desired package in the BIDS Solution Explorer window and selecting Deploy SSIS Package.
SSIS Deployment Configuration Options
On the first screen of the Package Deployment Wizard are the Deployment Options. In the Deployment Options, you can specify package configurations and other deployment options. In the Package Deployment Options box, you can choose to overwrite existing packages that are already deployed or to skip deployment of packages that already exist in the targeted environment. You can also specify the CheckPoint folder location, as well as the Package protection level. In the Configuration Deployment Options box, you can choose to deploy package configurations. You can also specify the location to deploy the package configurations to. You can also specify credentials to access remote file systems.
SSIS Deployment Package Explorer
After clicking next, you will see the Source and Target Selection screen. You can specify the location of the SSIS Packages that you wish to deploy, as well as the target location. From the Location drop down menus, you can set the source as either, File System, SQL Server, or SSIS Package Store. If you select a File System location, you will need to specify the correct path for the source and/or target location. If you select a File System location, you can specify a remote server as the locations for the packages. If you select a SQL server as the source and/or target location, you will need to specify the server and user credentials. If you select an SSIS Package Store as the source and/or target location, you will need to select the desired server and specify the path of the packages. (Filters can be applied by clicking the funnel icon next to delete.) You can edit the packages in Visual Studios before and/or after deployment by highlighting the desired package in the Selected Packages window and clicking the Visual Studios icon. This will open the selected package in Visual Studios and allow you to make any necessary changes. When you have specified the source and target locations, click the green arrow button to deploy the selected packages.
After the packages have been deployed and if the Show Log check box is checked, the Package Deployment Process Log will display. The log will display a summary of the deployment process, as well as a validation summary and application log. You can save the log for further review by clicking the Save Log button. When you have finished reviewing the Package Deployment Process Log, click the Close button to return to the Package Deployment Wizard.
When you have finished deploying the packages, click the Finish button to close the Package Deployment Wizard.