troubleshooting Question

64 bit DTEXEC compile error

Avatar of ChrisMoreland
ChrisMoreland asked on
Microsoft SQL ServerMicrosoft SQL Server 2005
6 Comments1 Solution2394 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
EugeneZ
SQL SERVER EXPERT

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros