This is part 7 of the series of article on SSIS
Introduction
In this article we are going to see on how to deploy a SSIS
package once we are done with developing, building and executing the package.
Deploying an application is something which we need to take care since it
performs based on the requirement like when the package should execute, who
should execute the package etc. We have 3 options available with deploying a
SSIS package and the options are as follows
1.
Deployment Utility
2.
Command line Executable
3.
SQL Server Management Studio
We will see on each approach and the steps involved in
deploying the package. You can refer to my previous articles on SSIS to get
some idea before going ahead with this article. The URL’s for those articles can be viewed at the below URL
SSIS Articles Part 1 to 6
Approaches
Approach 1 : Deployment Utility
This approach is used to create an installer for the package
and can be execute at the place where ever it’s required. This Utility is
available by default to all the Integration projects; we will see the steps to
make use of this utility.
Steps:
Go to BIDS (Check my previous articles on how to go to BIDS)
and open the package solution which you want to deploy and right click on the
project and go to properties as shown in the below figure.
A dialog will open where you have the option as Deployment
Utility. Clicking on that will show the options at the right side of the dialog
box where we need to set the CreateDeploymentUtility to TRUE and give the path
where the installer need to be created as shown in the below screen
Once we are done, now right click on the project and give
BUILD it will show the result at the bottom of the page if the build is
succeeded or failed. If it’s succeeded it will create the deployment installer
as shown in the below screen. You can copy these files to any location and
double click to make use of it
Approach 2: Command Line Executable
Microsoft has provided an Executable DTUTIL.EXE that can be
used to deploy SSIS packages. This command like utility is a good option to
script the package. We can use this executable directly or can make use of it
in the batch file.
To execute it at the command prompt check the below script.
Go to the path of the package and execute the below scripts.
DTUTIL
/FILE Package1.dtsx
/COPY
SQL;SSISPackage1
In order to deploy the package at the file system level then
go with the below script
DTUTIL
/FILE Package1.dtsx
/COPY
FILE;C:\SSIS\SSISPackage1.dtsx
For more option on this utility check the below url
http://msdn.microsoft.com/en-us/library/ms162820%28SQL.90%29.aspx
Approach 3: SQL Server Management Studio
This approach required integration services to be connected
and must be in running mode in order to use this deployment option. In the
object browser you can see something like below
To deploy our package right click on the File system and
select the Import Package from the menu. Fill the details as shown in the below
screen
Clicking on OK will deploy the package
Conclusion
This article describes on the options available to deploy
the SSIS packages.