SQL Server Performance Forum – Threads Archive

Schedule DTS package in Windows Scheduler

Hi,
Can anyone please let me know, How do we schedule a DTS package in Windows Scheduler. Thanks,
Suneel

create a batch file to run the dts package: type in the following in the notepad:
dtsrun /F "D:mydtspackage.dts" /E
where /E is for windows authentication
"D:mydtspackage.dts" is your DTS package location Save the notepad at the extension of .bat
Run the windows scheduler and schedule it to execute this file.

Use AT.EXE from command prompt for windows scheduler and can we know why you want to do this via WS. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.

Actually, On our server SQL Agent is not running and we don’t want to run for scheule the DTS job.
Satya,
We already have some schedule DTS on WS. But they are not setup as SMY said. I’ll try ur option and let know.

Any reason why SQLagent is not running or what kind of problems occurred when trying to start? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.

No specific reason. Could be start any time. But as per requirement we do not want to start.

]]>