DTSRun: Loading... -- then nothing - 07-20-2005 , 08:52 AM
Suddenly no dts jobs can be run using the dtsrun utility (or scheduled).
then nothing -- no errors -- nothing. Any ideas?
Re: DTSRun: Loading... -- then nothing - 07-20-2005 , 02:42 PM
In message <B4F16959-29AD-403B-B026-A18E09BC04D6 (AT) microsoft (DOT) com>, jl
<jl (AT) discussions (DOT) microsoft.com> writes
Check the version of dtsrun that is being used. If you had 7.0 installed
it relies on the PATH variable being correct, 2000 path before 7.0 path,
to find the correct version.
Check your TEMP and TMP location disks, as temporary space is required
for many packages and tasks.
Assuming local storage, run a profiler trace and watch for calls to the
msdb database, and the package loading procedure sp_getdtsackage (I
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
Re: DTSRun: Loading... -- then nothing - 07-20-2005 , 03:01 PM
Thank you for the reply.
Some additional info:
I tried copying in the dtsrun from a server on which the packages work fine,
and it still didn't make a difference. Version is 2000.80.534.0
There is a TEMP dir on both the server that is working and not working in
the same location. Plenty of space available.
DTSRun is not even getting to the stage of logging into the db -- no
profiler activity from it at all.
This stopped working suddenly with no errors in the event or error log.
"Darren Green" wrote: