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.
No comments:
Post a Comment