September 21, 2001 at 10:38 am
I was reading that with DTS 2000 you can redirect the output from DTS Run to a file. Can you do the same in 7? I was trying and kept getting an error that when had the > file name, it thought it was part of the name of the DTS Package.
Here is my line:
dtsrun /SAFNBLDDEV1 /Usa /E /N"PhoneTransfer - Daily File Load" > "D:\DTSShare\DTSErrorFiles\PhoneTransferFileLoad.txt"
September 24, 2001 at 12:19 pm
Server (remote): W2K Server, SP2 SQL2K, SP1
Workstation: W2K Pro, SP2 SQL2K Personal, SP1
Created package. One activeX task with the following:
Function Main()
msgbox("test")
print "test"
Main = DTSTaskExecResult_Success
End Function
Saved as "Test_Output" on remote server.
Ran this:
dtsrun /STank /E /Usa /N"test_output" > "u:\outputtest.txt"
displayed the msgbox and got this in the output file:
U:\>type outputtest.txt
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
DTSRun: Package execution complete.
Then did a "save as" and named the package "test output space"
Ran:
U:\>dtsrun /STank /E /Usa /N"test output space" > "u:\outputtest.txt"
Got the msg box and same result in output file. The u: drive is only visible from my workstation, not the server. I am not sure why it does not work for you, but can you try the same thing I did and repost?
Steve Jones
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply