If I execute an osql command from a dos/command prompt
like this
osql -S <servername> -E -i <inputSQLfile> -o <outputfile>
with all valid files, etc, I will get the SQL output in
<outputfile> and an empty <logfile>.
If the osql command fails, ie <inputSQLfile> doesn't
exist, I get error message(s) in <logfile>.
Good so far.

If I execute the exact same command within a DTS package
using an Execute Process Task, then this part of the above
command "> <logfile>" is invalid, so I can't get these
error messages.

Is there a way to make this work ?

Why would you need osql in DTS for this? It's simpler to use a Data
Transform Task from a SQL Server connection (input file) to a text file
connection (output file).

--
Jacco Schalkwijk
SQL Server MVP


"Jim Trowbridge" <jtrowbridge (AT) adelaidebank (DOT) com.au> wrote