SSIS Package Deployment Wizard

BI xPress - Peter Schott

"Finally got around to trial of BI xPress from Pragmatic Works - really wishing I'd done it a LOT sooner. Near real-time monitor==cool."

BI xPress - Verisk Health

"It’s such a cool and functionable tool/product mainly designed for the SSIS field."

Anil Maharjan

Software Engineer

Verisk Health, Nepal

BI xPress - Workforce Logic

"BI xPress has accelerated our development project by enabling rich configurable auditing and notification to our hundreds of packages without any code changes."

C. O'Connor

Data Warehouse Architect

Workforce Logic

BI xPress - Severstal NA

"BIxPress has really helped us in our ETL and in streamlining our SSIS Packages.. This product is a thumbs up for anyone doing SSIS Packages."

Akhil Mahajan

Sr. Software Developer

Severstal NA, Greater Detroit Area

BI xPress - Tech Data

"BI xPress has saved us an incredible amount of SSIS development time and allowed us to create new across the board development standards..."

Dave F.

Sr. SQL Server DBA

Tech Data

Buy Now Free Trial Download Compare Editions

BI xPress Package Deployment Wizard

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.

Feature Highlights:

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 Wizard

Package Deployment Wizard - Step 1

To open the deployment wizard, click on the BI xPress drop down in the BIDS toolbar. Select ‘Deploy SSIS Package (BI xPress)’.

Package Deployment Wizard - Step 2

Deployment Options

The deployment wizard offers many options developers and DBA’s can use to customize their package deployment.

Deploy Package

This will allow users to select their overwrite options. The options are to ‘Always Overwrite’, ‘Never Overwrite’, or ‘Prompt if Exists’.

Change CheckPoint Folder Location

If you want to change the location of your checkpoint file, the new path can be entered here.

Copy Folder Structures

This is useful when deploying multiple packages to a file system. BI xPress will copy folders and subfolders to the target location.

Compile Script Tasks/Components During Deployment

Automatically compile all scripts instead of compiling them manually one at a time in BIDS.

Deploy XML Config Files

When this option is selected, BI xPress will copy all configuration files to the target during deployment.

Change XML Config File Location

Allows the user to copy the configuration files to a different location and point the package to that directory during deployment.

Deployment Options

The deployment wizard offers many options developers and DBA’s can use to customize their package deployment.

Deploy Package

This will allow users to select their overwrite options. The options are to ‘Always Overwrite’, ‘Never Overwrite’, or ‘Prompt if Exists’.

Change CheckPoint Folder Location

If you want to change the location of your checkpoint file, the new path can be entered here.

Copy Folder Structures

This is useful when deploying multiple packages to a file system. BI xPress will copy folders and subfolders to the target location.

Compile Script Tasks/Components During Deployment

Automatically compile all scripts instead of compiling them manually one at a time in BIDS.

Deploy XML Config Files

When this option is selected, BI xPress will copy all configuration files to the target during deployment.

Change XML Config File Location

Allows the user to copy the configuration files to a different location and point the package to that directory during deployment.

Package Deployment Wizard - Step 3

Source and Target Selection

Clicking next will bring you to the Source and Target Selection screen. Here, users can choose what they are deploying and where they are deploying.

Source and Target Selection

Clicking next will bring you to the Source and Target Selection screen. Here, users can choose what they are deploying and where they are deploying.

Package Deployment Wizard - Step 4

To Deploy Packages

Select the source and the target. Both locations can be a file system, a SQL server, or a package store.
Select the packages below that you wish to deploy.
Choose the path on the target location.
Click the deploy button that points to the target.
Once all packages are deployed, a process log will appear.

To Deploy Packages

Select the source and the target. Both locations can be a file system, a SQL server, or a package store.
Select the packages below that you wish to deploy.
Choose the path on the target location.
Click the deploy button that points to the target.
Once all packages are deployed, a process log will appear.

Package Deployment Wizard - Step 5

Package Deployment Wizard - Step 6

2-Way Deployment

The deployment wizard features a 2 Way Deployment option. This will enable the deployment of packages from the target to be deployed to the source.

2-Way Deployment

The deployment wizard features a 2 Way Deployment option. This will enable the deployment of packages from the target to be deployed to the source.

View Our Suite of Pragmatic Works Products