Hey all,

Great idea - and perfect timing for me.

I am currently looking to rewrite some of our TL (E is done prior) to a better system then it currently runs on.

oCan be used for different systems (we have multiple systems that will use it)

oHas precedence, but can fail elements and continue others.

oHas parallelism where possible.

oIs easy to maintain

oWith detailed error logging, and simple monitoring

Currently i have considered SSIS (although not easy to maintain in my view) and using service broker to queue (a little complex).

What do people think of this article as an idea? So effectively i could have a set of tables to run this with - and procs to do the TL.

Thoughts?

Dan