Hi,

I encountered the following error message when running a dtsx Package -
which should insert the values from an Excel Package to an SQL Server
2005 table:

SSIS package "Dim_onetime.dtsx" starting.
Information: 0x4004300A at load Dim_Stay_Duration, DTS.Pipeline:
Validation phase is beginning.
Error: 0xC0202009 at Dim_onetime, Connection manager
"Excel-Dim_Stay_Duration": An OLE DB error has occurred. Error code:
0x80040154.
An OLE DB record is available. Source: "Microsoft OLE DB Service
Components" Hresult: 0x80040154 Description: "Class not registered".
Error: 0xC020801C at load Dim_Stay_Duration, Excel Source
Dim_Stay_Duration_Band [1]: The AcquireConnection method call to the
connection manager "Excel-Dim_Stay_Duration" failed with error code
0xC0202009.
Error: 0xC0047017 at load Dim_Stay_Duration, DTS.Pipeline: component
"Excel Source Dim_Stay_Duration_Band" (1) failed validation and
returned error code 0xC020801C.
Error: 0xC004700C at load Dim_Stay_Duration, DTS.Pipeline: One or more
component failed validation.
Error: 0xC0024107 at load Dim_Stay_Duration: There were errors during
task validation.
SSIS package "Dim_onetime.dtsx" finished: Failure.

Thanks

Hello Florian,

Does this discussion help any?

http://forums.microsoft.com/MSDN/Sho...60340&SiteID=1

Allan

I aalready solved it. It has something to do with the package runnning
on a 64bit machine and the JET Engine. I turned the 64bit runtime
environment off (right klick package Name) and it worked.




florian schrieb:

Where exactly did you change that option? I have a solution with many
packages. So I went from the Menu Project->Properties and changed it to be
False. However that didn't help, I still get the same error message.

Thanks,

Panos.

"florian" wrote:

I resolved this by doing the step above. But also you need to run your dts
package by the 32 bit dtexec executable not the 64. There are 2 versions
available. You create a operating system step instead of the usual. So you
enter "type operating system" when you create the scheduled job within sql
server and that worked fine for me.

Panos.
"Panos Stavroulis." wrote: