http://decipherinfosys.wordpress.com/2008/09/16/deploying-ssis-packages-in-sql-server-2005/
There are two options available for us to deploy the SSIS Packages.
a) File System Deployment:
As the name suggests, this option allows us to deploy the SSIS Project to the File System i.e. a physical location on the hard disk on the target server. If this option is chosen, we have to back up the SSIS Packages manually every night for any disaster recovery.
b) Sql Server Deployment:
This option allows us to deploy the SSIS project to the SQL Server i.e. on the MSDB database. Since the msdb is usually backed up every night, this method of deployment saves us some extra work of backing up the SSIS Packages manually if deployed using the file system.
SSIS Packages execution options:
Syntax: dtexec /option [value] [/option [value]]...
1. Command prompt
2. Using the xp_cmdshell extended stored procedure by using the dtexec command line utility
3.Using BIDS
There are two options available for us to deploy the SSIS Packages.
a) File System Deployment:
As the name suggests, this option allows us to deploy the SSIS Project to the File System i.e. a physical location on the hard disk on the target server. If this option is chosen, we have to back up the SSIS Packages manually every night for any disaster recovery.
b) Sql Server Deployment:
This option allows us to deploy the SSIS project to the SQL Server i.e. on the MSDB database. Since the msdb is usually backed up every night, this method of deployment saves us some extra work of backing up the SSIS Packages manually if deployed using the file system.
SSIS Packages execution options:
Syntax: dtexec /option [value] [/option [value]]...
1. Command prompt
dtexec /f "c:\pkgOne.dtsx" --File system
dtexec /sq pkgOne /ser productionServer -- SQL Server
2. Using the xp_cmdshell extended stored procedure by using the dtexec command line utility
EXEC xp_cmdshell 'dtexec /f "C:\UpsertData.dtsx"'
3.Using BIDS
No comments:
Post a Comment