During SQL Server SP2 timeframe a pending security update from the .NET Framework team was announced. That fix, when released would break any SSIS package using scripts. In response to this SQL Server Integration Services provided a fix into SP2 (as well as corresponding fixes for RTM & SP1) that would mitigate this issue, including log messages that would point to the KB below. The .NET Framework fix was released on Tuesday 7/10/2007 and thus we expect to see it surfacing on SQL Server Integration Services applications using scripts (both in data flow and control flow), most likely on machines running pure RTM and/or 64bit installations. The related KB article describing the impact to SSIS packages is available here: http://support.microsoft.com/kb/931846 Here are the details of the .NET Framework 2.0 fixes: http://support.microsoft.com/kb/928365 (for Windows XP/2003/2000)http://support.microsoft.com/kb/929916 (for Windows Vista)

For the group's reference and clarity:When I installed the hotfix (KB928365) on an SP1 installation, I received this error when validating a script task:"The task is configured to precompile the script, but binary code is not found"Installing SP2 corrected the validation error. Also note that you may get painted into a corner if you accidentally install the hotfix as I could not find an uninstallation for it, which means that you'll have to install SP2 to get things working again whether you were ready to or not. (Correct me if I'm wrong, please.)Phil

The fix for scripting in SSIS contains 2 components: - the .net framework fix (KB928365); - the SSIS fix (http://support.microsoft.com/kb/931846) which is incorporated in SQL Server SP2 but not in SP1 or RTM versions; Hope this clarifies the issue. Silviu Guea [MSFT], SSIS team

Silviu Guea [MSFT] wrote: The fix for scripting in SSIS contains 2 components: - the .net framework fix (KB928365); - the SSIS fix (http://support.microsoft.com/kb/931846) which is incorporated in SQL Server SP2 but not in SP1 or RTM versions; Hope this clarifies the issue. Silviu Guea [MSFT], SSIS team KB928365 breaks SSIS scripts in pre-SP2 versions. The "fix" is to install SP2 for SQL Server 2005 or one of the many hotfixes listed in http://support.microsoft.com/kb/931846.

Cant found KB928365 update in my machine. but the SSIS scripts still can't be edit after SQL SERVER 2005 sp2. THANK YOU yours ivan

Silviu Guea [MSFT] wrote: The fix for scripting in SSIS contains 2 components: - the .net framework fix (KB928365); - the SSIS fix (http://support.microsoft.com/kb/931846) which is incorporated in SQL Server SP2 but not in SP1 or RTM versions; Hope this clarifies the issue. Silviu Guea [MSFT], SSIS team KB928365 breaks SSIS scripts in pre-SP2 versions. The "fix" is to install SP2 for SQL Server 2005 or one of the many hotfixes listed in http://support.microsoft.com/kb/931846. Thanks for your effort! It's very detailed.