Hmm, I thought that only the first command was executed in the CmdExec steps of the Agent?

Try it like this:

del D:\IndependentExtracts\IndependentExtractsLog.txt

Bob Hovious 24601 (10/14/2009)

---

What next?

"You'll have to get the rest of your question answered by someone else... they're about to close the casket, and nobody bothered to put extra batteries...

Yes, this can be done, and somewhat easier than you describe, however there are some limitations and some very real security issues.

What you need to do is to establish a...

Simon Facer (10/13/2009)

---

I did originally design the system using Service Broker Queues, but that just added complexity without functionality, I finally realised that KISS applied, and stopped trying to using...

I think that you'll find the best string splitting routines, CLR, Tally Table and otherwise, in this thread here. It's long, but well worth the read.

Or is a Zen Koan like the Thread?

:Whistling:

Glad we could help, Preet, and thanks for the follow-up!

Glad we could help.

Have you tried using the EXEC..AT feature?

I did eventually get one also. 🙂

Very nice article. One suggestion would be to look into using Service Broker, as I believe that you will find that it can simplify or even enhance several aspects...

No, not so far as I know.

If your DTS packages implement logging, then you could check their logs.

Or if they each use a unique Login and you have auditing logs,...

Jeff Moden (10/10/2009)

---

Thanks for the offer. I appreciate it. Of course, I'll definitely throw the bone in the right direction on that.

By the way... thanks... I lost track...

Heh. I've been playing this one close to the vest until I had something that I could...

Yeah, but they're still "fun, fun, fun, fun, fun!"