Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
AKP2008
Starting Member
45 Posts |
Posted - 2009-08-11 : 09:59:37
|
Hi,I am calling web service using SSIS script task. When i execute the script task i am getting "The script files failed to load" error. Can you please suggest me what is the reason. How can i solve this issue.Thanks in Advance. |
|
tsaimrudula
Starting Member
3 Posts |
Posted - 2009-09-17 : 14:41:47
|
Hi all, I have the same issue. I have a script task which calls a webservice. I have the PrecompileScriptToBinaryCode set to true. I have also tried:a) Opening of the script task design windoe and closing it. b) removed all the break points in the design window.I'm really spending a lot of time solving this issue. Could somebody help out with this?Thanks in advance. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-17 : 14:55:11
|
I had this once - just occurred one day. Most annoying indeed. I had to open and save the package (and script task) on the server.What SP of SQL Server 2005 are you running? This maybe a fix from MS: http://support.microsoft.com/kb/931846 |
|
|
tsaimrudula
Starting Member
3 Posts |
Posted - 2009-09-17 : 15:15:40
|
Thanks a lot for replying to my issue. This error is really annoying me. I'm running it on sp3 i believe.I have run this script to find out the service pack:SELECT SERVERPROPERTY('ProductLevel') |
|
|
tsaimrudula
Starting Member
3 Posts |
Posted - 2009-09-17 : 15:17:59
|
I'm sorry, forgot to tell you that, it's working perfectly fine on my local machine (32-bit processor) where as when I try running on another server (which is 64-bit processor) it error out saying "script failed to load"Please help !! |
|
|
RedwoodAcoustic
Starting Member
1 Post |
Posted - 2012-03-02 : 10:47:51
|
This happened to me. I made sure PrecompileScriptToBinaryCode was set to True. I made sure no breakpoints were in the script. I made sure I opened and closed the script. Nothing worked. Still got the "script files failed to load" error. Then I found the problem. I was copying and pasting a lot of the script together and accidentally changed "Public Sub Main()" to "Private Sub Main()". Oops. Once I changed it back to public, the script worked fine. Hope this helps someone. |
|
|
PatMat
Starting Member
1 Post |
Posted - 2014-06-30 : 02:10:31
|
Ensure that you don't have your Public Class declared twice. This was the case with me and once I removed it, the error was also gone. |
|
|
|
|
|