Script Component can''t find the binary code

Dear all：

I have set the PrecompileScriptIntoBinaryCode property to true,but the Script Component show the message "can't find the binary code" after I finish the script language and save it . What's wrong with it ? I ever tried the same code, and it's OK with no problem. When did the problem happen ?

Please give me a help ....Thanks a lot!

If you are using a x64 Machine then you may face this problem. Under project properties, Debug option, set Run64bitRuntime to false. Now edit your script and save.. Reply if that persists..

Thanks

Subhash Subramanyam

|||And if you're not on 64-bit, make sure you have SP2 installed for SQL Server. (If you just recently applied the Microsoft patches, including the .Net 2.0 security fix, then your scripts will break.)|||

Hi all,

We are running on 32 bit machines with SP2 but still encountered this problem with script components that have been running for months without error. Even if I set almost all code to comment this persists.

This first appeared after the installation of the Microsoft July Security Patches MS07-036 --> MS07-041.

In the end, I was forced to set for these script components precompile to false. Does anyone know if a fix for this problem is planned in a future MS patch?

Kind regards,

|||

Paul,

Take a look through here for a hotfix:

http://support.microsoft.com/kb/931846

|||

Dears,

My problem was solved after installing SQL Server 2005 SP2.

I am in the same situation with Paul . The problem occured since I installed Windows Patches .

Phil, Thank you a lot~~

Script Component can't find the binary code

Dear all：

I have set the PrecompileScriptIntoBinaryCode property to true,but the Script Component show the message "can't find the binary code" after I finish the script language and save it . What's wrong with it ? I ever tried the same code, and it's OK with no problem. When did the problem happen ?

Please give me a help ....Thanks a lot!

If you are using a x64 Machine then you may face this problem. Under project properties, Debug option, set Run64bitRuntime to false. Now edit your script and save.. Reply if that persists..

Thanks

Subhash Subramanyam

|||And if you're not on 64-bit, make sure you have SP2 installed for SQL Server. (If you just recently applied the Microsoft patches, including the .Net 2.0 security fix, then your scripts will break.)|||

Hi all,

We are running on 32 bit machines with SP2 but still encountered this problem with script components that have been running for months without error. Even if I set almost all code to comment this persists.

This first appeared after the installation of the Microsoft July Security Patches MS07-036 --> MS07-041.

In the end, I was forced to set for these script components precompile to false. Does anyone know if a fix for this problem is planned in a future MS patch?

Kind regards,

|||

Paul,

Take a look through here for a hotfix:

http://support.microsoft.com/kb/931846

|||

Dears,

My problem was solved after installing SQL Server 2005 SP2.

I am in the same situation with Paul . The problem occured since I installed Windows Patches .

Phil, Thank you a lot~~

Script component as Destination - HasSideEffects?

How to set 'HasSideEffects' property for any input column of a script component used as destination?

My Script component reads input, generates SQL update statements dynamically and fires them. There is no output. When executing, I get this error (which is self-explanatory).

"Script Component" (1573) has been removed from the Data Flow task because its output is not used and its inputs have no side effects. If the component is required, then the HasSideEffects property on at least one of its inputs should be set to true, or its output should be connected to something.

How do I get around this?

thanks,
Nitesh

Which build do you have and how do you create the components?

I've tested the recent build, when I create a script component
or destination, the input is marked as HasSideEffect = true
(it is property of the input, not particular column AFAIK).

You can check this in Input and Outputs page in component
editor. Select the input, it has property HasSideEffect = true.
It is read-only though, but should have the correct value.|||I had the same problem running on the september CTP.

The "HasSideEffects" property of the input to the script component was not enabled, so I couldn't change it.

A workaround is to create a dummy output for the script component. This output will automatically get HasSideEffects set to True and the component will not be removed.|||I have June CTP.
But, HasSideEffects is a readonly attribute of Input and it is set to false.
I can't change it.

Yeah, for now I am using the work around of using a dummy output.

thanks,
Nitesh|||I tested this in the current build and if you select that the script task is a destination then the input automatically gets HasSideEffects set to true. When you say you had the same problem on the Sept CTP did you create a new script task as a destination or did you open an already existing script task (it won't change since the property is persisted).

Two workarounds:
1. Set the RunInOptimizedMode property on the dataflow task to false. This should stop it from removing component but could impact performance if some other pruning made your package run faster. If nothing else was being pruned then you will notice no perf impact at all.
2. Give your input a strange name (e.g. Fix hassideefects on this input) and then edit the xml directly and search for the strange name and change the HasSideEffects on that input to true. I don't recommended this since editing the xml directly can have serious consequences if done incorrectly but it can be done as a last resort if using option 1 affects your perf too much.

HTH,
Matt