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]




MS Sql Server LazyDBA home page