Guest_imported
New member
- Jan 1, 1970
- 0
- 0
- 0
I have a DTS package with some VBScripting used in formatting data and exporting it to a flat text file.
I'm trying to schedule it to run as a job within the SQL Server Agent. I use the following command line.
dtsrun /S <servername> /U <username> /N <dts name>
From the DOS command line it runs fine, but when I try to run it within a job it errors out every time. Any suggestions on what I might be doing wrong?
Thanks,
Jon
I'm trying to schedule it to run as a job within the SQL Server Agent. I use the following command line.
dtsrun /S <servername> /U <username> /N <dts name>
From the DOS command line it runs fine, but when I try to run it within a job it errors out every time. Any suggestions on what I might be doing wrong?
Thanks,
Jon