function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Andyw_UKAndyw_UK 

SSIS Script WSDL Error

Hi All,

 

Has anyone come across a problem with using SSIS & Visual Studio 2010 when adding a web service to a package script task (vb and c#)?

 

Error I am getting when trying to close the script editor is "Scripts in the package have compilation errors. Do you want to save changes"; when I click "yes" and look at the script Task it shows a error of "the binary code for the script is not found".

 

Just to confirm:

  • this happens for both enterprise and partner WSDL.
  • WSDL is downloaded from my development salesforce.
  • This is not a prolem with my code (As I dont add any).
  • The script task builds with no errors.
  • Happens with C# and VB
  • Using Visual Studio 2010 SP1

Has anyone else come accross this problem?

 

Cheers

Andy

Ashish_SFDCAshish_SFDC

Hi Andy,

 

This error is specific to the SSIS script,

Please see the links below which have solutions for the error, which say changing the script task property to false solves the issue.

Microsoft Article: http://support.microsoft.com/kb/932557

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=158334

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/6665928e-c3fe-46f9-a426-1e9721ef61f6/ssis-2008-the-binary-code-for-the-script-is-not-found

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/be015a20-b7c0-4711-b1a6-906fbd844b66/error-the-binary-code-for-the-script-is-not-found-please-open-the-script-in-desiner-by-clicking

http://stackoverflow.com/questions/2470037/ssis-script-task-pre-compile-script-into-binary-code-set-to-false

 

Regards,

Ashish, Salesforce.com

 If this post answers your question, please mark this post as Solved.
Andyw_UKAndyw_UK

Thanks Ashish however this just supresses the error, when you execute the task you still get an error:

 

"The binary code for the script is not found.  Please open the script in the designer by clicking Edit Script buttom and make sure it builds successfully"

 

As mentioned before it does build correctly.

 

When looking at the error list in VS I can see the following:

 

"Custom tool warning: Schema validation error: Schema item 'simpleType' named 'FaultCode' from namespace 'urn:fault.partner.soap.com' is invalid. The Enumeration constraining facet is an undelcared prefix."

 

Cheers

Andy