March 1, 2006 at 10:16 am
I have a DTS package, call it foo.dts, which has everything I need to execute a DTS. I would like to call that package every hour on the hour to perform the tasks within foo.dts. I've been looking at utilities such as dtsrun but haven't found a decent example and I've tried to tread through it myself. Can anyone demonstrate of point me to an example similar to my issue?
March 1, 2006 at 11:03 am
Have a look at the dtsrunui utility. It can generate a dtsrun command that can be put in a job step of a scheduled SQL Agent job. For an example, see
http://www.sqldts.com/default.aspx?301
Greg
Greg
March 1, 2006 at 11:08 am
"C:\PROGRAM FILES\MICROSOFT SQL SERVER\80\TOOLS\BINN\Dtsrun.exe" /F "[.dts]"
you can pass variables like so...
/A[var name]="[value]"
March 1, 2006 at 11:17 am
That did it. Thanks to all.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply