http://blogs.msdn.com/mattm/archive/2006/11/01/conditional-constraints.aspxHere's a more practical example of using constraints based on variables. I have a package that requires an existing database file to be attached to the local SQL Server. The package is synced out to multiple machines from a source control system and runen-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/mattm/archive/2006/11/01/conditional-constraints.aspx#8926484Fri, 05 Sep 2008 19:25:22 GMT91d46819-8472-40ad-a661-2c78acb4018c:8926484Anup Pachlag<p>Nice post - It would be good to add which version of SSIS this is using. We need everything versioned, including our posts ! </p> http://blogs.msdn.com/mattm/archive/2006/11/01/conditional-constraints.aspx#8926526Fri, 05 Sep 2008 20:03:59 GMT91d46819-8472-40ad-a661-2c78acb4018c:8926526mmasson<p>I believe this post was done before 2008 was available. :) Normally I mention the product version if what I'm talking about is version specific, or there are differences in behavior. </p> <p>In this case, things are the same for both 2005 and 2008....</p> http://blogs.msdn.com/mattm/archive/2006/11/01/conditional-constraints.aspx#9502367Mon, 23 Mar 2009 22:51:03 GMT91d46819-8472-40ad-a661-2c78acb4018c:9502367dmasino<p>Good info on using multiple constraints. Thanks!</p>