This is an interesting and a common requirement of locking the schema once the SSIS package is created. Else I have seen manytimes the nasty error and we need to open the package to re-validate the Tasks. Check this post from Roche that explains how to mitigate this using simple views.
This entry was posted on Monday, September 15th, 2008 at 04:43 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.