dtexec

I have saved a copy of a package to a 64-bit server running Windows 2003 Enterprise Edition SP1. I changed the Run64BitRuntime to true before saving the package. When I try to use DTExec to execute the package which does have a script task in it I receive the below error.

Error: 2005-08-17 16:52:32.89
Code: 0x00000005
Source: Script Task 1
Description: The script files failed to load.
End Error

Any help is appreciated.

Thanks.In your script task set PreCompileScriptIntobinaryCode=TRUE

This is a known issue with 64-bit machines. The default setting for this property (as of the next CTP) has been set to TRUE because of it.

-Jamie|||Jamie is correct that the default value of this property has been changed from False to True. The Integration Services team opted for 64-bit convenience at the cost of increased package size. 32-bit users may want to measure the impact of this setting if package size is ever a concern.

-Doug|||Thanks you guys - I have been able to get the packages scheduled.

DTA Common Error and sp1

Does anyone know if sp1 resolves the common DTA error "failed to initialize CRT"? I found this KB article on it http://support.microsoft.com/Default.aspx?kbid=913395, yet this resolution did not work for my boxes (i have both a laptop and desktop with 2005/build 1399 developer). I did not notice this error being listed in the http://support.microsoft.com/kb/916940

Thanks,

Derek

Guys,

2.Also please check if an environment variable __COMPAT_LAYER is set?
"set __COMPAT_LAYER=" , basically disabled the compat layer and dta
ran OK

i added this EV and DTA now works, but I shouldnt have to do this. Does sp1 resolve and if not I assume sp2?

|||I went ahead and applied sp1 all common components (this DOES INCLUDE CLIENT COMPONENTS) of sp1/x86 and sure enough it works? Where is this listed in the sp1 fixes?|||for the sake of clarity, the first fix (environmental variable) was applied to my laptop. the second fix (sp1 common components) was applied to my desktop.