Hello friends, today we are going to learn very important part of SSIS package i.e. its deployment.There are three ways through which we can deploy our SSIS package. We will learn all three ways of deployment of SSIS package. Lets see what are those three ways of SSIS package deployment.
- Using deployment utility
- Using DTUTIL command line tool
- Using SQL Server management Studio
Using deployment utility:- To deploy our SSIS package using deployment utility, we need to create the deployment utility first. I have already created a SSIS package so that we should only focus on the deployment part. Lets create a deployment utility for already created package. To create deployment utility, we will click on the “Project” menu of the BIDS(business intelligence development studio) and click on the “Properties” menu( As shown in the below screenshot).
As soon as we click on the properties menu, a new window will appear in front of us(Shown below).
We will set the value of field “CreateDeploymentUtility” to “True” and we can also specify the path of the deployment utility underneath “CreateDeploymentUtility” field. In my case, I haven’t changed the path. Now we will click on “OK” button to close the window. To create the deployment utility, we will right click on the project and rebuild our project by clicking on the “Rebuild” menu(Shown below).
Once we rebuild the solution, deployment utility will be created in the bin folder. In the bin folder there will be two files one is deployment utility and the other one is the package file. The file type for the deployment utility would be “Integration services deployment manifest”, we will double click on the deployment manifest file that will open a UI (As shown in the below screenshot).
Now, we will click on “Next” button that will bring a new UI in front of us(As shown below).
We will select “SQL Server deployment” instead of “File system deployment” as file system deployment can be done manually. We will click on “Next” button that will bring another UI(As shown below).
In the above screen, we will provide the “Server Name”, in my case, I am deploying the package at my local machine. We will specify the authentication mode(Windows or SQL Authentication) and the last step would be to specify the package path. To specify the storage path of the package, we will click on the button(encircled by red color) that will open a popup window(As shown below).
In the above screen, we will select the “SSIS Packages” node and click on “OK” button to close the window. Now we are back to the previous screen(As shown below).
We will click on “Next” button that will bring another UI (As shown below).
We will click on “Next” button to proceed further and then again click “Next” that will bring the final screen(As shown below).
We will click on “Finish” button to finish the setup. Now we are done with the deployment.
Lets see the location of the deployed package. To see the location of the package,we will open the management studio and connect with the Integration Services engine (As shown below).
Instead of selecting the “Database Engine” , we will select the “Integration Services” and click on the “OK” button. Since we haven’t given any name to our package hence its name is showing as “Package”(As shown below in the screenshot).
I hope you will find this article useful. In my forthcoming articles, I will talk about other ways of deploying SSIS package. Please feel free to ask any question related to this article.