SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 The script files failed to load error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AKP2008
Starting Member

45 Posts

Posted - 08/11/2009 :  09:59:37  Show Profile  Reply with Quote
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

USA
3 Posts

Posted - 09/17/2009 :  14:41:47  Show Profile  Reply with Quote
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.
Go to Top of Page

YellowBug
Aged Yak Warrior

United Kingdom
616 Posts

Posted - 09/17/2009 :  14:55:11  Show Profile  Reply with Quote
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
Go to Top of Page

tsaimrudula
Starting Member

USA
3 Posts

Posted - 09/17/2009 :  15:15:40  Show Profile  Reply with Quote
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')


Go to Top of Page

tsaimrudula
Starting Member

USA
3 Posts

Posted - 09/17/2009 :  15:17:59  Show Profile  Reply with Quote
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 !!

Go to Top of Page

RedwoodAcoustic
Starting Member

1 Posts

Posted - 03/02/2012 :  10:47:51  Show Profile  Reply with Quote
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.
Go to Top of Page

PatMat
Starting Member

1 Posts

Posted - 06/30/2014 :  02:10:31  Show Profile  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.17 seconds. Powered By: Snitz Forums 2000