Post reply

SSIS does not recognize CozyRoc Excel Connection Manager

  • December 9, 2011 at 8:00 am

    #247497

    I create an OLE DB Source and an Excel Destination Plus Task.

    I execute the package and DDID does not recognize the Excel Connection manager Type.

    Error: 0xC0014005 at : The connection type "EXCEL+" specified for connection manager "Excel Connection Manager 1" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.

    Error: 0xC0010018 at : Error loading value "<DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts">

    <DTS:Property DTS:Name="DelayValidation">0</DTS:Property>

    <DTS:Property DTS:Name="ObjectName">Excel Connection Manager 1</DTS:Property>

    <DTS:Property DTS:Name="DTSID">{D840793C-6116-47A" from node "DTS:ConnectionManager".

    Failed to load the package "Exception deserializing the package "The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.

    ".".

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • December 9, 2011 at 8:08 am

    #1419398

    I had to change the Debug Option 64bitRuntime to False.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • December 12, 2011 at 3:18 am

    #1419914

    Welsh Corgi (12/9/2011)

    I had to change the Debug Option 64bitRuntime to False.

    You should also do that when you are not using CozyRoc but regular SSIS tasks dealing with Excel.

    Doesn't have CozyRoc a customer support forum? I can imagine that not a lot of people here at SSC have experience with CozyRoc.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 12, 2011 at 6:58 am

    #1420058

    Koen Verbeeck (12/12/2011)

    Welsh Corgi (12/9/2011)

    I had to change the Debug Option 64bitRuntime to False.

    You should also do that when you are not using CozyRoc but regular SSIS tasks dealing with Excel.

    Doesn't have CozyRoc a customer support forum? I can imagine that not a lot of people here at SSC have experience with CozyRoc.

    Yes, I set that option to False when using regular SSIS. I forgot this time.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • December 13, 2011 at 12:44 pm

    #1420829

    Welsh Corgi (12/9/2011)

    I had to change the Debug Option 64bitRuntime to False.

    Compared to the standard Excel adapters, CozyRoc adapters support both 32bit and 64bit execution. Make sure you did use the 64bit installation for 64bit machines.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply