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]




MS Sql Server LazyDBA home page