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