Post reply

Excel connection throws error in Data Flow Task

  • January 6, 2010 at 9:19 am

    #140539

    Hi,

    I am trying to import data from Excel file into one DB table. We have two different dev servers and in one of the server I got the below error when I run a package with a data flow task which does the same.

    [Excel Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel_Source" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

    But the same package is working in another server. Can any one help me to understand what's wrong in the first dev server? Would there be any thing that I need to check for in Visual Studio set up?

    Thanks,

    Suresh

    Regards,
    Suresh Arumugam

  • January 6, 2010 at 11:48 am

    #1099819

    Is the machine it's failing on 64 bit?

    There is no 64 bit driver for Excel.

    See links for more information and a workaround.

    http://technet.microsoft.com/en-us/library/ms141766.aspx

    http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/a4fc47b9-d029-4e7c-952d-9e9f666cf2e8/

  • January 7, 2010 at 4:00 am

    #1100095

    Thanks Erick.

    I got the issue solved by setting the "Run64BirRuntime" property to FALSE in BIDS. I understand this fix only for Design time.

    However, the same package is running with out any set up changes when deployed into Integration services. I am trying to understand (in the same 64 bit server),why the package runs in Integration services but not in BIDS.

    Regards,

    Suresh

    Regards,
    Suresh Arumugam

Viewing 3 posts - 1 through 3 (of 3 total)

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