I am trying to create a SQL Server Agent job to run a DTS package, but the job fails with an " Invalid command options" error. The job has only one step of type Operating System Command (CmdExec). The command I have entered is:
DTSRun /~N TEST_Import_SettlementExposures
where TEST_Import_SettlementExposures is the name of the DTS package. If I go to the DTS package and schedule it from there, the scheduled job runs fine, but the DTSRun command references the GUID of the DTS package. I will be moving this DTS package and job to another computer, so I can't just script the scheduled job as the GUID will be different on the new machine.
What is the proper syntax for the DTSRun command in the job step command window?
I am sure it is something stupid that I am overlooking, but I just can't see it.
I greatly appreciate any help with this.