Hoda,

That is what I did, except that the parameters were strings. Replacing the parameters with the strings directly in Management Studio worked fine so it's quite happy with the conversion...

Just had a chance to look into this but I can't see how to use a RAW file as the source for a lookup. Am I missing something obvious?

Ian

Thanks for that. It gave me just what I was after.

Ian

Thanks for that, I'll look into it. I've rewritten the package to use set based operations and the 90 minutes has now come down to 10, which the business are...