In SSIS, a deployment is a process to update the package state from development mode to executable mode. You can deploy by right-clicking the operations on the integration services project and then selecting the build option. This will create the “package. dtsc” file under the bin folder. You can use the deployment utility for deploying the packages at the SQL server.
You can follow these steps for creating a deployment utility :
* Navigate to Project and right-click on it
* Double click on the properties option
* You can choose the path for your deployment by selecting the box next to “True” available under the Create Deployment Utility
* Close the window after saving all the changes
* Right-click again on the project and then click the build option. A deployment folder will be created under the BIN folder.
* Find the .manifest file in the deployment folder
* To perform the package deployment on the SQL server, double-click the manifest file and choose the deploy option
