Running DTS Packages


Data Transformation Services (DTS) is an older SQL Server platform for the visual design and execution of data transformation routines. It is still supported in SQL Server 2005. The old engine is also present on the installation disk and you can decide to install it on your server if you have some old DTS packages. I will show you how to run a DTS package from a stored procedure.

SQL Server 2005 includes the dtsrun.exe utility, which allows you to execute DTS packages from the command prompt. Again we can simply call it using xp_cmdshell:

 exec xp_cmdshell 'dtsrun /SmyServer /Udbo /E /NDW_ETL '               +  '/ADatabase:8=Asset5 /AServer:8=myServer', NO_OUTPUT 




Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL &  .NET
Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
ISBN: 0072262281
EAN: 2147483647
Year: 2006
Pages: 165

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net