Post reply

SSIS and oracle

  • October 6, 2008 at 8:59 pm

    #123864

    when i try to execute ssis package retrieving data from oracle i get the below error.

    SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.

    The AcquireConnection method call to the connection manager

    Please let me know how to solve this error.

    Thanks

  • October 6, 2008 at 9:09 pm

    #881411

    Have you installed the relevant Oracle products on the workstation / server that you are running your SSIS packages from ? I would expect that as a minimum, you need to install SQL Net

  • October 9, 2008 at 12:09 pm

    #883070

    You probabably will also need a TSNAMES.ORA file on your workstation with the appropriate Oracle connection strings.

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

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