Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

SSIS 2012 Project Deployment

  • 18 June 2012
  • Author: ShawnHarrison
  • Number of views: 38171
  • 0 Comments

There have been some rather significant changes made to SSIS in SQL Server 2012. One of which is package deployment. In 2005 and 2008, one could easily deploy packages to the MSDB. In 2012, this has been changed. Before you can deploy anything, there has to be an integration services catalog.

 

Here are the steps to deploying a project in SQL Server 2012 for the first time.

 

In SQL Server Data Tools (I already miss simply typing out BIDS). Right click the project name. In the context menu, is the ?Deploy? option.

 

image

 

Click deploy and the deployment wizard opens. From the intro screen, click ?Next? and choose the server name.

 

image

 

Click the browse button to select a path and the following message is shown.

 

image

 

So, before I go any further, I have to create an SSISDB. So open management studio and connect to the database instance.

Right click on the Integration Services Catalogs node, and select ?Create Catalog?.

 

image

 

 

This opens a window with a set of options to create the catalog. Be sure to first enable CLR Integration and then create a password for the encryption key.

 

image

 

Click ?OK? and the SSISDB is added.

 

image

 

Now, go back to Data Tools. In the Solution Explorer, right click the project name and select ?Deploy? to open the deployment wizard again. Click ?Next? and choose the server name. For the path, click ?Browse?. You can now select the root of your SSISDB catalog.

 

image

 

Click ?New Folder? and create a folder to which you can deploy the project.

 

image

 

Click ?OK? and now select the new folder.

 

image

 

This takes you back to the ?Select Destination? window. Click Next.

The ?Review? screen will give a summary of what will be deployed, and how.

 

image

 

Click ?Deploy? to deploy the entire project. Once deployment is complete, the deployment wizard will display a results page.

 

image

 

Close the wizard and go back to management studio. Refresh the object explorer window. Expand the SSISDB and all the folders that are created below that. The packages are visible in the packages folder underneath the project name.

 

image

Print
Tags:
Rate this article:
No rating

ShawnHarrisonShawnHarrison

Other posts by ShawnHarrison

Please login or register to post comments.