Hmm, I haven't got much at the moment.

You have a consistent problem, at least, as scheduling a job sets up a
DTSRun command, and your problem occurs when doing DTSRun manually.

I take it there are no obvious errors reported, just the incomplete
results?

Is it possible that you could take the Active X task code out into a
development tool and step through it to see if you can spot the problem
(or get someone to do this for you?). I mean anything that does VBA
would do. It's a damn shame (polite version) that VBScript doesn't allow
proper error trapping, but that's how it is and we have to live with it.

If you (or anyone available at your office) is handy with VB(5 or 6)
then you could get them to knock together a program WITH proper error
handling that does the same loop calling DTSRun to try to see what's
going wrong with it(or even going on!).

You could try sticking the profiler on, and you might get *some* hint,
but probably not (hey, I'm a pessimist).

If you post the Active X script, we can try to see if there's anything
obvious, but I don't think the problem is there by fact that it runs
fine when executed manually.

This sounds rather similar to my DTS/C# woes - hopefully you will
actually find a solution!

> -----Original Message-----
> From: Uday Shivamurthy
> [mailto:mssqldba-ezmlmshield-x21600876.[Email address protected]
> Sent: 25 November 2004 01:28
> To: LazyDBA Discussion
> Subject: RE: Problems with DTSRun[Scanned]
>
> Hi Kirsty,
>
> Yes, SQLAgent runs under a domain a/c and I've made this the
> "local admin"
> on the box. Please keep your wheels turning and help me out here...
>
> Regards,
> Uday
> .....................................
> Direct: +61-2-98059739
> Mobile: +61-401 705907
> Email: [Email address protected]
>
>
> -----Original Message-----
> From: Pollock Kirsty
> [mailto:mssqldba-ezmlmshield-x52521319.[Email address protected]
> Sent: Wednesday, 24 November 2004 11:06 PM
> To: LazyDBA Discussion
> Subject: RE: Problems with DTSRun[Scanned]
>
> And does the NT account under which your your SQLagent
> service runs have sufficient rights on the file system? I've
> been caught out by that one a few times.
>
> > -----Original Message-----
> > From: Hugh du Toit
> > [mailto:mssqldba-ezmlmshield-x25271497.[Email address protected]
> > Sent: 24 November 2004 11:54
> > To: LazyDBA Discussion
> > Subject: RE: Problems with DTSRun[Scanned]
> >
> >
> > Does your SQLagent account have sufficient rights on all the tables?
> >
> > -----Original Message-----
> > From: Uday Shivamurthy
> > [mailto:mssqldba-ezmlmshield-x56742361.[Email address protected]
> > Sent: Wednesday, November 24, 2004 13:52 PM
> > To: LazyDBA Discussion
> > Subject: Problems with DTSRun[Scanned]
> >
> > Hi all,
> >
> >
> >
> > SQL 2K Ent Edition Service pack 3a.
> >
> >
> >
> > I have only 1 dts package that is made to loop using an active-x
> > script. I basically have to bcp out data from our
> Statistics database
> > to flat files for archiving purposes.
> > The package runs fine and loops the way I want it to only when I
> > manually "execute" package.
> >
> >
> >
> > I schedule it to run using SQLAgent, this fails with the message "..
> > Process Exit Code 1. The step failed.", in this mode it
> > appears that the package kicks off and only outputs one
> > table, out of about 35 tables, and comes to a halt.
> >
> >
> >
> > I tried running it using DTSRUN /S"local" /Usa /P "password"
> > /N "my silly dts package" /V {some long number} /L
> > "C:\log.txt" /W0 --> this way the package tries to run, but,
> > looping does not happen and I end up only getting one table
> extracted.
> >
> >
> >
> > Appreciate any input from your gurus.
> >
> >
> >
> > Regards,
> >
> > Uday
> >
> > .....................................
> >
> > Direct: +61-2-98059739
> >
> > Mobile: +61-401 705907
> >
> > Email: [Email address protected]
> >
> >
> >
> >
> >
> >
> ---------------------------------------------------------------------
> > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > Website : http://www.LazyDBA.com To unsubscribe:
> > http://www.lazydba.com/unsubscribe.html
> > For additional commands, e-mail: mssqldba-[Email address protected]
> >
> >
> >
> >
> >
> >
> ---------------------------------------------------------------------
> > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > Website : http://www.LazyDBA.com To unsubscribe:
> > http://www.lazydba.com/unsubscribe.html
> > For additional commands, e-mail: mssqldba-[Email address protected]
> >
> >
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: mssqldba-[Email address protected]
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: mssqldba-[Email address protected]
>
>

MS Sql Server LazyDBA home page