Please help...

On our production server, I have a DTS package which executes an exe
which calls a batch file that invokes an osql session and runs a query
(MS blocking script logger).

When i run the dts package from my workstation, it creates the dos
session on my machine... but when the package is invoked by the
schedule job, the job runs successfully, but the osql/query session is
never invoked.

Any advice will be much appreciated.

Thanks in advance,

Dan.

Have a read of this and see if it helps

http://support.microsoft.com/?kbid=269074

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Dan Coates" <danielcoates (AT) yahoo (DOT) com> wrote