excel import error 0xC020801C "cannot acquire connection from conn

Discussion in 'microsoft.public.sqlserver.dts' started by adolf garlic, Apr 26, 2007.

  1. adolf garlic

    adolf garlic Guest

    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!
     
    adolf garlic, Apr 26, 2007
    #1
    1. Advertisements

  2. 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, Apr 30, 2007
    #2
    1. Advertisements

  3. adolf garlic

    adolf garlic Guest

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

     
    adolf garlic, May 1, 2007
    #3
  4. adolf garlic

    adolf garlic Guest

    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, May 8, 2007
    #4
  5. adolf garlic

    adolf garlic Guest

    If I run the whole package there is no problem - the xls is opened and
    extracted.
    If I run the task in isolation it is failing every time with the error
    message.

     
    adolf garlic, May 8, 2007
    #5
  6. adolf garlic

    Javier Jugo Guest

    In the standart bar, select:
    1. Project
    2. [your solution] Properties
    Last option
    3. Configuration Properties, Debugging
    4. Select "False" in Run64BitRunTime
    With this change the package will run correctly.
    good luck!!!



    adolfgarli wrote:

    If I run the whole package there is no problem - the xls is opened and
    08-May-07

    If I run the whole package there is no problem - the xls is opened an
    extracted
    If I run the task in isolation it is failing every time with the erro
    message

    :

    Previous Posts In This Thread:

    excel import error 0xC020801C "cannot acquire connection from conn
    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!

    The xls does not have a password.
    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 :

    :

    Hello adolf,Can I just confirm that it fails when running through BIDs
    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 Mitchel
    http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com
    http://www.konesans.com

    I have started getting the same error again.Even after reboot I am getting it.
    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

    :

    If I run the whole package there is no problem - the xls is opened and
    If I run the whole package there is no problem - the xls is opened an
    extracted
    If I run the task in isolation it is failing every time with the erro
    message

    :


    Submitted via EggHeadCafe - Software Developer Portal of Choice
    Win A Free License of SandDock for Silverlight
    http://www.eggheadcafe.com/tutorial...free-license-of-sanddock-for-silverlight.aspx
     
    Javier Jugo, Jul 29, 2010
    #6
  7. adolf garlic

    John Andrews Guest

    Perfecto, Javier! I got the same error while migrating a package from SQL Express version (2008) to SQL Server 2005. From that, I assume that my local ThinkPad and SQL Express installation is 64-bit, and the 2005 installation is 32-bit. Thank you so much!

     
    John Andrews, Mar 22, 2011
    #7
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.