Ironic that in this issue of SQLServerCentral we have an article about formatting (with very easy to read SQL examples) and this article with code that was unreadable at a...

Thanks for the link, I'll check it out.

Ah, see if I'd just thought about it for a second or two before posting this message...

We've come up with a solution:

Create a logging table.

Create a stored proc to insert...

Thanks again for your help.  The logic of the code matches what I'm trying to achieve, so hopefully I'll get the result I'm after.

Thanks for the help so far.  If my child DTS returns a 'Y' I want to continue processing in the parent DTS.  If my child DTS returns an 'N' I...

That's excellent - thanks very much 🙂

Thanks for the tip - I'll give it a go 🙂

Bah - aruge all day about number 1 being correct if you want, but you're wrong.  If you paste the script into Query Analyser and run it, neither of them...

Thanks for all the information 🙂

The use of an 'execute package task' is working well.  However, if I change the package that does the validation a new version is created.  This means that my parent packages will point...

I once had a similar problem.  A child package would not execute when the parent package was run, but I could execute the child package on its own.

The problem was...

Ooo, yes that's a good idea!  Despite using DTS packages within DTS packages elsewhere, I had never considered it for this problem.  I'm off to give it a go...

Thanks 🙂

DiscountASP.net provide MS SQL hosting and they allow connections via Enterprise Manager.