SQL Server Performance Forum – Threads Archive
use local packages in an external schedulerHi, How can I use local packages in an external scheduler? For all jobs in the company we use an external scheduler (CONTROL M ).
Once per week I must send data from oracle database to sql server database. For this I use DTS.
All work fine but I don#%92t know to use this in our external scheduler.
Thanks for your help
quote:To execute a DTS package saved as a COM-structured storage file, use: dtsrun /Ffilename /Npackage_name /Mpackage_password To execute a DTS package saved in the SQL Server msdb database, use: dtsrun /Sserver_name /Uuser_nName /Ppassword /Npackage_name /Mpackage_password To execute a DTS package saved in Meta Data Services, use: dtsrun /Sserver_name /Uuser_nrame /Ppassword /Npackage_name /Mpackage_password /Rrepository_nameIf I got the question right, the answer is: schedule dtsrun with proper parameters.
Thanks, i will test it