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.

Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
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

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