How to deploy SSIS package to SQL Server 2012 SSISDB Catalog

In this post, I’m going to present how to deploy SSIS package to SQL Server 2012 integration services catalog.

  • Create SSIS catalog

1.png

2.png

  • After step 1 you can see SSIS catalog name called “SSISDB”  created. Right click and create a folder “TestSSISPackages”

4.png

 

5.png

 

6

  • Now create a visual studio SSIS integration sample package. For the purpose of this demo I have created a sample package called “TestSSIS”.

7

  • After the step 3, right click on project name and click deploy

8.png

  • The below screen will appear for deploying the package, follow the screenshots to complete the package deployment

9.png

 

10.png

 

11.png

 

12.png

 

13.png

 

14

 

15.png

  • After the step 5, you can see that the package “TestSSIS” deployed in SSIS catalog as shown below.  There you go!

16.png

Hope you enjoyed the post!

Cheers

Ramasankar Molleti

LinkedIn: LinkedIn Profile

Twitter: Twitter

 

About Ramasankar

My name is Ramasankar Molleti, I have been working on various database and cloud systems (SQL Server, Oracle, PostgreSQL, DynamoDB, Redshift, Amazon, Azure) over 12 years, primarily focusing on Architect , Development, Administration and Business intelligence. I hold various Certifications such as Amazon Web services Solution Architect Associate, Microsoft certifications (Microsoft Certified Information Technology Professional, Microsoft Certified Technology Specialist, and Microsoft Certified Solution Associate).
This entry was posted in SSIS. Bookmark the permalink.

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s