Deployment is nothing but a PROCESS of updating the state of the package from development mode to executable mode. Deployment in SSIS can be done by simply performing the right-click operation on the “INTEGRATION Services Project” and clicking on the BUILD option. This would create a “package.dtsx” file inside the bin folder named “projectbin”. The utility HELPS in deploying packages at SQL server or as an executable file on a SPECIFIED location.

Following are the steps followed to create a deployment utility:

• Go to Project and right-click on it.
• Double click on the properties.
• Choose the path location for deployment by selecting the box next to “True” under Create Deployment Utility.
• Save changes. Close this window.
• Right-click again on the project and select the build option. This creates a deployment folder in the project’s root within the BIN folder.
• The deployment folder will have a .manifest file.
• Double-clicking on the .manifest file and selecting the deploy option will perform package deployment on the SQL server.