Home > SSIS > Deploy SSIS Package in One click

Deploy SSIS Package in One click


SQL Server 2012 Intergation Sevices made SSIS deployment very simple (reference). This single click deployment feature is not available in the previous versions.

But, we have got a command line utility dtutil.exe 32bit/64bit versions. So, we can make use of this utility to accomplish our task.

In this article, I will be showing you to set up one click deployment this feature in BIDS SQL Server 2008 r2 to deploy SSIS packages from BIDS. Before starting my blog, I would like to give you another utility software that enhance Microsoft BIDS IDE. This utility software helps developing SSIS/SSAS solution faster . The name of the utility software is BIDS helper. Explorer more about this utility in Codeplex.com

Implementation

Summary: Setup additional menu item in BIDS to deploy SSIS package in one click.

Step 1: Open Microsoft Business Intelligence Development Studio.

Step 2: Add a ne SSIS project and Got to Tools menu and click External Tools… menu item

Step 3: Click Add button and Enter Deploy text in the title textbox.

Step 4: Select appropriate DTUTIL.exe version 32bit or 64bit in command column.

Step 5: construct the argument to deploy SSIS package

/FILE $(ItemPath) /DestServer SQLSSIS /COPY SQL;\$(ItemFileName) /Quiet

$(ItemPath): It is the BIDS variable that gives you the current SSIS package file location with name.

$(ItemFileName) : It is the BIDS variable that gives you the current SSIS package file name.

SQLSSIS: Your name of the SSIS server to deploy dtsx package.

 

Step 6: Check Use Output Window option. This option will help developer to see the command line utility output such as error, warning and etc. in the BIDS.

Step 7: Click OK.

Step 8: Deploy your package now.

Output window in BIDS

Thanks for reading.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: