How to deploy SSIS package-Part 2

Hello friends, in my last article we saw how to deploy a SSIS package using deployment utility. In this article we will learn how to deploy SSIS package using DTUTIL deployment tool. Lets see how to deploy SSIS package using DTUTIL deployment tool.We already have SSIS package ready with us hence we are just going to focus on deployment part.

We will open command prompt and type below command to deploy the SSIS package in MSDB database.

DTUTIL  /File “C:\Users\Neeraj\Documents\Visual Studio 2008\Projects\Integration Services Project7\Integration Services Project7\bin\package.dtsx” /destserver “Neeraj-PC”  /copy  SQL;package

Lets break the above command in small parts so that we should be able to fully understand the all parameters of the command.

DTUTIL  /File “C:\Users\Neeraj\Documents\Visual Studio 2008\Projects\Integration Services Project7\Integration Services Project7\bin\package.dtsx” /destserver “Neeraj-PC”  /copy  SQL;package

I have broken the command in four parts and each part is being indicated by different color.

Green Color:- We are calling the DTUTIL exe.

Yellow Color:- We are specifying the path of our SSIS package.

Grey Color:- We are specifying the instance name of our SQL Server, if you are deploying the SSIS package on local server in that case this parameter can be removed.

Pink Color:- Copy command will copy the package in MSDB database with name “Package”, we can also change the name of this package.

Package deployment using Management studio:- We have already seen two ways of deploying SSIS package, lets see how we can deploy SSIS package using management studio.First of all, we need to login to the Integration Services engine(As shown below).

Instead of selecting “Database Engine”, we will select “Integration Services” as shown above and click on connect button. Once we login successfully to the “Integration Services” engine, the screen will look like as shown below.

We will right click on the “MSDB” database and click on “Import Package” menu that will bring a new screen in front of us(As shown below).

In the screen shown above, we will select the “Package location” as File System, since we are importing our package from file system. Now we will click on the button(Encircled with red color) to specify the location of the package. As soon as we click on the button a new window will open up(As shown below)

We will select our package and click on the “Open” button that will close the above screen and we will be back to the previous screen(Shown below).

If you want to give some relevant name to your package, you can do it by renaming the “Package Name” field. Finally, we will click on “OK” button that will close the current screen and our package will be deployed successfully(You can see in the below screenshot).

I hope you will find this article useful, please feel free to ask any question related to this article.