"adolf garlic" wrote:

> I have started getting the same error again.
>
> Even after reboot I am getting it.
>
> Preview data works ok but when trying to open the xls it is failing with the
> same error:
> SSIS package "Package2.dtsx" starting.
> Information: 0x4004300A at Add new CIFs to destination, DTS.Pipeline:
> Validation phase is beginning.
> Error: 0xC020801C at Add new CIFs to destination, Manual DCIb 1 [67]: SSIS
> Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The
> AcquireConnection method call to the connection manager "Manual DCIb" failed
> with error code 0xC0202009. There may be error messages posted before this
> with more information on why the AcquireConnection method call failed.
> Error: 0xC0047017 at Add new CIFs to destination, DTS.Pipeline: component
> "Manual DCIb 1" (67) failed validation and returned error code 0xC020801C.
> Error: 0xC004700C at Add new CIFs to destination, DTS.Pipeline: One or more
> component failed validation.
> Error: 0xC0024107 at Add new CIFs to destination: There were errors during
> task validation.
> SSIS package "Package2.dtsx" finished: Success.
>
> "adolf garlic" wrote:
>
> > The xls does not have a password.
> > I was just using preview to see that the connection worked and that the data
> > would be as expected. When I try and run the package it was returning the
> > error below.
> >
> > I am not getting the error now but don't know what has changed :(
> >
> > "Allan Mitchell" wrote:
> >
> > > Hello adolf,
> > >
> > > Can I just confirm that it fails when running through BIDs immediately after
> > > you preview the data?
> > >
> > > Do you have to provide a password for the Excel file?
> > >
> > > --
> > >
> > > Allan Mitchell
> > > http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
> > > http://www.konesans.com
> > >
> > > > I have inherited a package and am struggling to get it working.
> > > >
> > > > It is failing at the point of trying to open an XLS.
> > > >
> > > > I have tested the connection and am able to preview the data ok. (I am
> > > > running in BIDS/VS.NET)
> > > >
> > > > When I try executing the task I receive the following error:
> > > > Error: 0xC020801C at Load Excel Barriers, Excel Source [1]: SSIS Error
> > > > Code
> > > > DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The
> > > > AcquireConnection
> > > > method call to the connection manager "Manual DCIa" failed with error
> > > > code
> > > > 0xC0202009. There may be error messages posted before this with more
> > > > information on why the AcquireConnection method call failed.
> > > > I can't find anything on the web about it.
> > > >
> > > > Hayulp!
> > > >
> > >
> > >