dtexec

Hot Topic

problem with dtexec
SQL Server 2005 Standard edition install fails; An instance with the same name.../
MDX Help - Should be easy
Connection managers - OLE DB
I'd like to get a good book of SQL...
how to get the sum of a group and not the whole column?
SSRS Question?
I am practicing by building a PM Online App
What happens during package validation
Processing cube from SSAS - OLE DB error

SQL Server

SQL Server 2005 Service Pack 1 is now available
Missing Fields in XML DataSet
Reports Questions
Merge Join - Add Cross Join
Cross Row Referential Integrity
Soundex support for foreign languages
multiple calls to SP
Filling up ListControl from a SQL query
Redistributing SQL2k5 Express
how to start work in SQL Server 2005 enterprise edition

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.

Answer this question

dtexec

  • ashok.hingorani

    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

  • JuanCarlosUlti

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

  • Rob Holland

    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


  • dtexec
Answer this question