"Panos Stavroulis." wrote:

> 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 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:
> >
> > > 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
> >