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
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 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.