0

I'm seeing that a lot of people are having this issue and so am I. I'm using Visual studio 2015 SSDT 2014 and SQL server 2014. I created a package that has a script task in it, inside the script task I'm using a web reference to a SOAP API.

when i run the package from my design environment (Visual studio) that package successfully executes. when I deploy the package to the integration services catalog I get the following error: "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."

I know that from SSDT 2012 and higher the "precompiled binary" option is set to true.

what am i missing?

any help would be appreciated.

Elad L.
  • 629
  • 1
  • 10
  • 25

1 Answers1

0

have try tried to add service reference, instead of web reference ?

  • keep backup of proxy class that generated by web reference
  • delete the web reference
  • add same service as service reference
  • replace newly generated proxy class with the backup in step 1
Hiran
  • 1,102
  • 11
  • 18