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.dts x" /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_MAXIMUMERRORCOUNTREA CHED. 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
DECLARE @returncode int
EXEC @returncode = xp_cmdshell'dtexec /f "\\Server\SSIS\package.dts
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_MAXIMUMERRORCOUNTREA
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
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.co
---
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
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.
ASKER
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.dts x" /De "password"'
success2.bmp
Here is the string I am using to kick it off
DECLARE @returncode int
EXEC @returncode = xp_cmdshell'dtexec /f "\\Server\Share\import.dts
success2.bmp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I use script task in 64-bit machine without problem. what I did was to build each script task.
Cheers
Cheers