Script Component WebService Binary code for the script is not found

I am using SSIS 2012 to access a Public Web Service
 http://marketinformation.natgrid.co.uk/MIPIws-public/public/publicwebservice.asmx

However, when adding reference to WebService (not Service Reference),
I receive the dreaded msg "Binary code for the script is not found"

I have spent an age ploughing through the forums.
Many replies seem to suggest not using Script Component to acces WebService.

Should I write a .NET app  ?

Any thoughts how I should proceed would be most welcome.

thanks JohnJames

April 22nd, 2015 9:07am

Perhaps you have this property set to FALSE

Set the Precompile... to TRUE

Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2015 2:02pm

Arthur, thanks for reply, however it is a Script Component I am using 
April 22nd, 2015 2:50pm

Hi JohnJames,

If I understand correctly, you already add this public web service via Add Service Reference option in the Script Component. Then you receive the error message when you trying to call the bindings and Contract settings stored in app.config file to access the web service.

Please note that we cannot all the web service normal way as SSIS Script Component task doesnt recongnise the app.config file. To fix this issue, we should define the BINDINGS via code rather than depending on the App.config file. For more details, please see the following blog:
http://social.technet.microsoft.com/wiki/contents/articles/22587.consume-webservice-via-ssis-script-component.aspx

Thanks,
Katherine Xiong

Free Windows Admin Tool Kit Click here and download it now
April 28th, 2015 2:29am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics