That's good Michael!

I was one of those that was torn between the TWO correct answers and chose the wrong one!

David

One of the better articles I've seen on this (sorry it's on another site) is here: http://www.15seconds.com/Issue/020715.htm

Though ISNULL does do the single alternative, COALESCE has the double added benefit of

1) being ANSI standard and supported bu more platforms and

2) allows multiple options.

If I'm testing several...

You should be able to set all the connection values in one Dynamic Property Task. I have a package we're using for data migration (from Oracle to SQL Server) that...

Thanks Gabor ...

To answer your questions ...

1) the "WHERE 0=0" is a construct I use to help format the code a little and make it easier to comment out lines...