Link to home
Start Free TrialLog in
Avatar of ChrisMoreland
ChrisMoreland

asked on

64 bit DTEXEC compile error

I am running a SSIS package from SQL using the following script

DECLARE @returncode int
EXEC @returncode = xp_cmdshell'dtexec /f  "\\Server\SSIS\package.dtsx" /De "password"'

however I keep getting the following errors -- any ideas? I am attempting to get out DTS packages moved to SSIS I exported the DTS packages and am working on getting one to run so then I can change all of the others accordingly. I use these to import data from flat files into databases on the SQL box.

--ERROR--
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
NULL
Started:  2:30:24 PM
Error: 2008-08-12 14:30:24.45
   Code: 0x00000009
   Source: Change destination
   Description: The task cannot execute in 64-bit environment because the script is not pre-compiled. Please turn on the option to pre-compile the script in the task editor.
End Error
Error: 2008-08-12 14:30:24.45
   Code: 0xC0024107
   Source: Change destination
   Description: There were errors during task validation.
End Error
Warning: 2008-08-12 14:30:24.45
   Code: 0x80019002
   Source: Package
   Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specifie
d in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
End Warning
DTExec: The package execution returned DTSER_FAILURE (1).
Started:  2:30:24 PM
Finished: 2:30:24 PM
Elapsed:  0.172 seconds
NULL
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

And you have not applied or cannot apply SP2 to SQL Server 2005, right?

check
Script Task cannot execute in 64-bit environment  
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3039960&SiteID=1
---
I see that you have sp2 - however:
please review:
FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1399
http://support.microsoft.com/kb/932557 
Avatar of ChrisMoreland
ChrisMoreland

ASKER

OK I cannot seem to find where i need to set the Pre compile feature to true - I am working in the BI studio - I have the package open and am in design mode but cannot find where to set this to true.
I can run the package in BI stuidio but when i run itfrom a script in SQL studio I get the error

Here is the string I am using to kick it off

DECLARE @returncode int
EXEC @returncode = xp_cmdshell'dtexec /f  "\\Server\Share\import.dtsx" /De "password"'

success2.bmp
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I use script task in 64-bit machine without problem. what I did was to build each script task.
Cheers