You can use: xp_cmdshell and dts run utility to execute DTS package from store procedure. You can create statement like exec master..xp_cmdshell 'dtsrun /Uuser_name /Ppassword /Sserver_name /Npackage_name /Mpackage_password' Please read more about xp_cmdshell & dtsrun from SQL Server Books Online. Regards