Debunking the Myths: Cloud HA and DR common misconceptions

Learn more about SQL Server tools



solving sql server problems for millions of dbas and developers since 2006 join MSSQLTips for free SQL Server tips
































   Got a SQL tip?
            We want to know!


Deploying SSIS Packages  

Overview
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.

 



 
Sponsor Information







Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | free t-shirt | user groups | community | events | first timer?
Some names and products listed are the registered trademarks of their respective owners.