CODEWITHSUNDEEP
sql-server-2005
Phil
Phil

Reputation: 263

How to I add SSIS Packages to the MSDB database on SQL Server 2005?

I have SQL Server 2005 install on my PC and am having execution problems with an SSIS Package stored in the filesystem. I want to stored this in the MSDB database but don't know how to do this.

I watched this video: http://download.microsoft.com/download/5/3/0/5303799D-8739-4BDC-8062-337368357391/SQLServerAgentTroubleshoot.wmv

This video guides you through the process in SQL Management Studio, however it shows Integration Services as a separate section in Management Studio and I don't have this?

Any ideas how I can see Intergration Service in Management Studio or how I can add the package to the MSDB database without it?

Upvotes: 3

Views: 14941

Answers (4)

Marcel Balcarek
Marcel Balcarek

Reputation: 89

Using the CreateDeploymentUtility option is relevant if you are using the older package deployment model, but not if you are using the project deployment model I believe.

I also do not see the"File > Save Copy of PACKAGENAME.dtsx as ...", choose "SQL Server" option when using the Project deployment model.

Upvotes: 0

Dom
Dom

Reputation: 201

If still of interest, how to build the package for deployment:

  1. in BIDS, right click on the solution (top of the right side bar) and select Properties.
  2. Under Deployment Utility, set CreateDeploymentUtility option from False to True.
  3. Right click on the solution (top of the right side bar) and click on Rebuild.
  4. Now go to the solution project folder. In the folder "...\bin\deployment\" you will find an Integration Services Deployment Manifest. Right click on this, select Deploy and then follow the wizard steps. The SSIS should then appear in SQL Server Management Studio under Integration Services in \MSDB.

Upvotes: 0

Kyle Hale
Kyle Hale

Reputation: 8120

Alternatively, if you built your SSIS package in BIDS you can go to the menu, choose "File > Save Copy of PACKAGENAME.dtsx as ...", choose "SQL Server" as the destination and fill in the server name. You'll also get to choose the protection level of the package regarding sensitive data, you can view all of your options at MSDN.

Upvotes: 3

cjk
cjk

Reputation: 46485

In the Object Explorer in Management Studio, the Connect button has a drop down that allows you to specify Integration Services. You can use this to get to your MSDB package repository.

However, to get your SSIS package in there, the easiest way is to build it for deployment so you get a .manifest file. Run this and you can choose to install it to MSDB.

Upvotes: 4

Related Questions