Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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
 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  
 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.94 seconds. Powered By: Snitz Forums 2000