SSIS 64-bit reading excel problem
-
I've got an SSIS package loaded up which runs run when I execute the package, but not within an sp, or if I just generate it through an open query window.
I've tried the below with no luck and seem to be getting nowhere.
I have RunINOPtomizedMode, InteractiveMode, and Run64BitRuntime all set to False.
declare @cmd varchar(150)
select @cmd = '"C:\PROGRA~2\MICROS~2\90\DTS\Binn\DTExec.exe" /sq WUEERPImport /ser sho2k3ms80'
exec master..xp_cmdshell @cmd
which gives this error:
Description: Opening a rowset for "VRA$" failed. Check that the object exists in the database.
Description: "component "VRA" (275)" failed validation and returned validation status "VS_ISBROKEN".
and more below
This :
declare @cmd varchar(150)
select @cmd = '"C:\Program Files\Microsoft SQL Server (x86)\90\DTS\Binn\dtexec.exe" /sq WUEERPImport /ser sho2k3ms80'
exec master..xp_cmdshell @cmd
gives the following error:
'C:\Program' is not recognized as an internal or external command,
operable program or batch file.
NULL
Here's the full summary:
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
NULL
Started: 11:04:08 AM
Progress: 2008-08-04 11:04:09.39
Source: Data Flow Task
Validating: 0% complete
End Progress
Progress: 2008-08-04 11:04:09.41
Source: Data Flow Task
Validating: 25% complete
End Progress
Error: 2008-08-04 11:04:09.43
Code: 0xC0202009
Source: Data Flow Task VRA [275]
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
End Error
Error: 2008-08-04 11:04:09.43
Code: 0xC02020E8
Source: Data Flow Task VRA [275]
Description: Opening a rowset for "VRA$" failed. Check that the object exists in the database.
End Error
Error: 2008-08-04 11:04:09.47
Code: 0xC004706B
Source: Data Flow Task DTS.Pipeline
Description: "component "VRA" (275)" failed validation and returned validation status "VS_ISBROKEN".
End Error
Progress: 2008-08-04 11:04:09.47
Source: Data Flow Task
Validating: 50% complete
End Progress
Error: 2008-08-04 11:04:09.47
Code: 0xC004700C
Source: Data Flow Task DTS.Pipeline
Description: One or more component failed validation.
End Error
Error: 2008-08-04 11:04:09.47
Code: 0xC0024107
Source: Data Flow Task
Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 11:04:08 AM
Finished: 11:04:09 AM
Elapsed: 1.062 seconds
NULL
-
Solved this myself, turns out it was a simple issue around the worksheet being renamed by someone :ermm:
-
IN SQL 2008 use the following switch added to your command line..
/X86
Or you can use the tab that has Execution Options .. there is a checkbox there for USE 32 bit runtime..
These options are not supported in SQL 2005. Sorry
-Jason Donahoe
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply