SSIS Tip – Save Package to MS SQL Server (Integration Services)

In order to save your SSIS package built using Business Intelligence Development Studio (BIDS) to Integration Services MSDB, you’ll need to:

  1. In BIDS, right-click the solution and select Properties
  2. Under Deployment Utility, change the CreateDeploymentUtility option from False to True
  3. Rebuild the solution
  4. Now find in your solution project folder under the bin\deployment file path an Integration Services Deployment Manifest. Right-click this manifest file and select Deploy.

Follow the wizard steps to deploy to your server and choose where to save to the database. The package should then appear in SSIS in SQL Server Management Studio under Integration Services in /MSDB.

Leave a Reply

Your email address will not be published. Required fields are marked *