This is really easy to do. Create several variables (global) that will be used to pass your info.

Then you will have to use a Script Task inside of the...

I ran into the same problem when we upgraded to SQL2K5. It does in fact process a NOT IN query very different than SQL2K especially if the subquery is...

Like anything...it depends on the job you're trying to do. If all you have is a hammer then everything looks like a nail. Each version of temp tables...