.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Options to Deploy a package in SSIS - SQL Server Integration Services (SSIS) - Part 7

Posted By:Karthikeyan Anbarasan       Posted Date: February 27, 2011    Points: 100    Category: DataBase    URL: http://www.dotnetspark.com  

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
 

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 are as follows.

This is part 7 of the series of article on SSIS. Other part of my SSIS articles at the below urls

Basics of SSIS and Creating Package - SQL Server Integration Services (SSIS) - Part 1

Transforming SQL Data to Excel Sheet - SQL Server Integration Services (SSIS) - Part 2

Export Data using Wizard - SQL Server Integration Services (SSIS) - Part 3

Import Data using Wizard - SQL Server Integration Services (SSIS) - Part 4

Building and Executing a Package - SQL Server Integration Services (SSIS) - Part 5

Options to execute a package in SSIS - SQL Server Integration Services (SSIS) - Part 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.


 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend