SSIS script task pre-compile script into binary code set to false

If I set pre-compile script into bi开发者_运维百科nary code to true I get error saying "The task is configured to pre-compile the script, but binary code is not found." If I set this property to False then it works. Will it be a problem after I deploy package on production server? Please advice.

The binary code would need to be pre-compiled if you are running production in 64-bit, is this the case? Sounds like there is a syntax error in your script code though, can you post it here so we can see what the problem might be?

You shouldn't have any problem if you don't have to deploy to a 64-bit machine. From MSDN:

If the script is precompiled it will start more quickly and the script can run in a 64-bit environment. However, the package size is larger when it contains precompiled scripts. Moreover, compiled script cannot be debugged

This a problem acknowledged by Microsoft (in Sql Server 2005), and you can find a fix here

Just to inform that I tried this update in my SQL Server and it never worked. I had to set precompile in the script task properties to off

In my simple C# script task, I was getting the error -

Package Validation Error

Error at Send Mail: The binary code for the script is not found. Please 
open the script in the designer by clicking Edit Script button and 
make sure it builds successfully. Error at Send Mail: There were 
errors during task validation.

 (Microsoft.DataTransformationServices.VsIntegration)

In my case I was just using a simple try catch block to catch Exception in simple code. I added a using System.Exception; I got the error after that. I just realized that this import is not needed and is the cause of the error. I don't know why it causes an error in SSIS.

In my case I had forgotten to add the reference to Microsoft.Exchange.WebServices.dll.

I was able to solve it by reading the official Microsoft documentation, which describes how to reference it.