Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


Deploying SSIS Packages


When we are ready to deploy our packages we have the following options available:

  • Deploy to the file system
  • Deploy to the package store
  • Deploy to SQL Server

The simplest approach to deployment is probably to deploy to the file system.  As SSIS package is actually just an XML file and it can simply be copied from its project location to a folder on the deployment target.  You can use the DOS COPY command, Windows Explorer, etc. to perform the copy operation.  The package store is a particular folder on the file system; the default for SQL Server 2005 is C:\Program Files\Microsoft SQL Server\90\DTS\Packages.  SSIS packages deployed to SQL Server are stored in the msdb database.

There are three ways to deploy our packages:

  • Create a deployment utility from our project
  • Use the DTUTIL command line tool
  • Use SQL Server Management Studio (SSMS)

In this section of the tutorial we will discuss the deployment options.


Last Update: 10/22/2009

More SQL Server Solutions

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Thursday, May 31, 2018 - 3:55:19 AM - Harshit Back To Top

I'm having a problem while deploying SSIS Package in Integration Services Catalog. It gives me error like this when I try to create a folder in SSISDB "Operation 'Create' on object 'CatalogFolder[@Name=SSISTEST']' failed during execution. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.5058.0+((SQL11_PCU_Main).140514-1820+)&LinkId=20476

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account that uses Windows Authentication. The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account that uses Windows Authentication. (Microsoft SQL Server, Error: 27123)"

It seems like I cannot use SQL server authentication user for creating a catalog. When I was trying to Deploy the project through BIDS the same thing happens it's going to use windows authentication which is not valid in my case.

Is there any way I can use SQL server authentication for deployment purpose.

Thursday, August 31, 2017 - 8:53:00 AM - Namita Back To Top


Can you tell me if it is possible to deploy SSIS 2014 packges to file system and SQL server I see only one option to deploy in SSIS catalog.

When i try to automate my package through SQL agent they still show 4 options to pick up a package i.e. file system,ssis package store,sql server, SSIS catalog. But, I can only deploy package using SSIS catalog. 


Learn more about SQL Server tools