Submit My Question - Recent Questions - Recent Answer

Msdn Tech >> SQL Server >> SQL Server Integration Services

JOB With SSIS Step Fails If Package Contains A Script Task

I have a Job Step defined to execute a SSIS Package. This SSIS package contains a Script Task. The Job fails with the message "Package execution failed. The step failed."

I am logging events in the package and when the packages gets to the Script Task the log reports "The script files failed to load". If I disable the Script Task from the package it executes fine.

Curiously, the package runs successfully with the Scritp task enabled using dtexecui and dtexec from the command line.

Only if I include the Package in a job step with the Script Task enabled does it fail.

Any help would be appreciated.

[614 byte] By [SteveWenck] at [2007-12-16]

«« What happened to the Richtextbox in 2005?
»» Basic VB coding question about changing label text on the fly, etc.

# 1

I've no real idea about this Steve except to say have you got the script code pre-compiled? If so, try it without (and vica versa).

-Jamie

JamieThomson at 2007-9-9 >

top of Msdn Tech,SQL Server,SQL Server Integration Services...

# 2

Sorry for not posting this sooner, Jamie...Yes, setting the Script Task "PrecompileScriptIntoBinaryCode" Property to True resolved the issue.

-Steve

SteveWenck at 2007-9-9 >

# 3

hey - did you ever get this to work? Im having the same issue - its a SSIS pkg that ran on one box and I moved to another box (64 bit if that makes a diff) - any info is greatly apprecaited - thanks.

Juantana at 2007-9-9 >

# 4

Juantana,

Yes, set your Script Task "PrecompileScriptIntoBinaryCode" Property=True and then open and close your script. Save, redeploy and it should work. Let me know if you have any questions.

-Steve

SteveWenck at 2007-9-9 >

# 5

Hi,

Inspite of putting the PrecompileScriptintoBinarycode Property = True, it is not working. Do you have any suggestions?

Thanks.

bani3 at 2007-9-9 >

# 6

After settings Precompile to True, you need to open and close script editor(s) to actually precompile the script in the task. Then re-deploy the pockage to target system.

MichaelEntin-MSFT at 2007-9-9 >

# 7

Also remove all the break points in the code, having break points prevents from recompilation. I guess this issue would be fixed by SP2

Selvalakshmi at 2007-9-9 >

# 8

Just an FYI I had all my scripts set to PrecompileScriptIntoBinaryCode=True however when developing in 32bit and deploying to 64bit seemingly randomly I will get the "script failed to load" error. I just open the script and compile it again and save and that usually does the trick.

ChrisHoncoop at 2007-9-9 >

# 9

Also if the problem still persists and you keep getting the same error I am sure you are not taking the dtsx file from bin folder to execute. The file created by designer (Business Intelligence Development Studio) is only useful for debug and development mode. After building the solution one should use dtsx created in bin folder. This solution worked for me.

Thanks

Mohit

MohitGupta at 2007-9-9 >

# 10

NOTE: I got this same error message with Precompile option set to True.

Problem was that a variable name script used was not passed in. Go figure

TheViewMaster at 2007-9-9 >

# 11

I have about 30 dtxs that I would like to recompile its scripts to solve this issue. I would like to avoid to open each package, then open each script in the package and do the save to recomplie.

Is there a way to recompile from the command line?

Thanks!

PaulinoPP at 2007-9-9 >

# 12

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

ChrisHoncoop at 2007-9-9 >

# 13

Chris Honcoop wrote:

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

Sounds like it might be a bug. Could you submit it at http://connect.microsoft.com?

-Jamie

JamieThomson at 2007-9-9 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Question about 'JOB With SSIS Step Fails If Package Contains A Script Task', No.68546,Posted by SteveWenck

JOB With SSIS Step Fails If Package Contains A Script Task

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified