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]


MS Sql Server LazyDBA home page