Good article. I'm not using SSIS currently, but I like the path of exploring and researching in finding a solution.

I'm wondering if this would work in making the contract SQL simpler to build than the IF block.

[font="Courier New"]SELECT ContactID

, FirstName

, MiddleName

, LastName, Suffix

, EmailAddress

FROM #Contact

where 1=2[/font]