Hi all!
I'm running 7.0. I have a DTS package that simply transfers a table from one database to another. It works fine manually. I'm trying to save the package as a file so I can run it in a job (Server Agent) using dtsrun. From within DTS package editor, it appears as though I'm saving the file to C:\MSSQL7\Binn\Tradeshow.dts, but when I use Explorer to locate the file, it's not there. Explorer indicates there are no *.dts files on the server. I copied the file path from the DTS editor into the cmdexec window so that the command reads:
dtsrun /F "C:\MSSQL7\Binn\Tradeshow.dts"
(i've tried this without the quotes too)
and i get this error:
DTSRun: Loading... Error: -2147287038 (80030002); Provider Error: 0 (0) Error string: The system cannot find the file specified. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 704. Process Exit Code 1. The step failed.
-----
Needless to say, I'm more than confused.
Thanks!
ixnay5
I'm running 7.0. I have a DTS package that simply transfers a table from one database to another. It works fine manually. I'm trying to save the package as a file so I can run it in a job (Server Agent) using dtsrun. From within DTS package editor, it appears as though I'm saving the file to C:\MSSQL7\Binn\Tradeshow.dts, but when I use Explorer to locate the file, it's not there. Explorer indicates there are no *.dts files on the server. I copied the file path from the DTS editor into the cmdexec window so that the command reads:
dtsrun /F "C:\MSSQL7\Binn\Tradeshow.dts"
(i've tried this without the quotes too)
and i get this error:
DTSRun: Loading... Error: -2147287038 (80030002); Provider Error: 0 (0) Error string: The system cannot find the file specified. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 704. Process Exit Code 1. The step failed.
-----
Needless to say, I'm more than confused.
Thanks!
ixnay5