running dtsrun command from DOS prompt on win xp with SQL Server 2000 - 01-14-2005 , 06:57 PM
I have a DTS package. When I run it from a DOS prompt as following,
c:>dtsrun /S sql_server /U userid /P pwd /N dts_package_name
Eveything is fine. I can see something like log messages output from the
Then if I redirect output into a file like and run it again,
c:>dtsrun /S sql_server /U userid /P pwd /N dts_package_name >output_file
then the command never come back from it running. I'm sure the dts package
itself has finished running by check the output_file. The output_file said
like that the package has completed.
Thanks in advance!