Script Task: Cannot load script for execution.
We've recently migrated SSIS servers; both are using SQL 2008 R2. The old machine was 32 bit and the new machine is 64 bit, if it matters. When we try to run the package we now get "Script Task: Cannot load script for execution." Any ideas? The code is unfortunately too long to post but I've already change all of the variable assignments to happen inside of a function.
September 22nd, 2011 8:10pm

Jelling, This could be due to a very large number of potential problems with your script. You've already taken care of the most common problem, assigning variables outside a function. When you run your package, do you have any other transformations that work correctly, before the script task starts? Since you just moved the package to a new machine I want to make sure the problem is isolated to just the script component and not a problem with a connection or other general package problem . If it seems to be just the script component all I can suggest is start incrementally commenting out blocks of code until it at least runs without an error, and then start putting code back in. Also put some message boxes throughout the code to see how far it's getting into the script component, if at all. Tom Overton
Free Windows Admin Tool Kit Click here and download it now
September 22nd, 2011 9:08pm

Hi jelling, The 64-bit editions of Microsoft SQL Server include Integration Services, but some Integration Services features are available only in 32-bit versions, or have limitations on 64-bit computers, or are not supported on Itanium-based operating systems. For more details about it, please refer to the following article, 64 bit Considerations for Integration Service: http://msdn.microsoft.com/en-us/library/ms141766.aspx Thanks, Eileen Forum Support Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
September 23rd, 2011 5:36am

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

Other recent topics Other recent topics