Deploying the SSIS Package

Overview

---

When you create an SSIS package, you can deploy it to a server. Doing so allows you to run them from the management studio. You can also automate the imports or exports, setting them to run at a particular time each day.

To deploy a package, you first must create and run it to make sure it works. You will need to use both Microsoft Sql Server Management Studio and The Data Tools in Visual Studio. The data tools will need to be run with Administrator privileges.

Setting up the SSIS Catalog

---

Open Microsoft SQL Server Management Server.

In the Object Explorer locate the folder for "Integration Services Catalogs."

Right Click on it and Select "Create Catalog." If you have not already enabled CLR (Common Language Runtime) integration you will receive the following dialog.

Check the box to enable the CLR. You will need to provide a password. I am using the old standby "P@ssw0rd1." In real life, make sure you use a more secure password.

Now the catalog is created.

Deploying the Package

---

Now, if you haven't done so already, open the SSIS project in Visual Studio. Make sure you are running with Administrative Privileges. Right click on the project in the Solution Explorer.

Choose "Deploy" from the context menu. This launches a wizard.

Click Next

For the source I key in "Localhost." When I click "Browse" for Select Path, I see the Integration Catalog I created in the Management Studio.

Click Create new folder. I named the folder "GrantRequestsPackage" and provided a brief description

Click OK and OK, then Next.

You are given a screen to review the process so far.

Click "Deploy". If all goes well you should see the following screen.

Return to the SQL Server Management Studio. Expand the Integration Services Catalog. Expand the SSIDB, Expand the GrantRequestPackage Folder and the Projects Folder. You should see your package there.