Post reply

Connecting Sybase through SSIS 2008

  • May 25, 2011 at 9:13 am

    #240979

    Hi,

    We installed oledb driver v2.60 on SQL 2008 server. After installing we tried to connect to the sybase server by using SSIS 2008.

    We are able to configure the Sybase oledb using oledb connection manager.

    But we are unable to find the Sybase driver in the SSIS 2008 connections provider list.

    Please tell us how to find the Sybase driver in SSIS 2008 connections provider list.

    Any help on this is really appreciated:sick:

    Thanks

  • May 25, 2011 at 9:20 am

    #1329750

    My first guess is a 32/64-bit problem..

    I'm guessing that the OS and SQL are 64-bit and the drivers either didn't say or are 32-bit. If so, you will not be successful using these in a linked server and in SSIS you will be required to run the package with the 32-bit DTExec.

    Unfortunately this is often the cause of these kind of issues.

    CEWII

  • May 26, 2011 at 5:01 am

    #1330162

    Hi,

    We are able to find the Sybase ASE provided in SQL 2008 provider list after registering the dll file.

    We are able to connect to the Sybase while testing the connection. We are having problem while executing the SSIS package. It was displaying the following error:

    [Execute SQL Task] Error: Failed to acquire connection "PR_Sybase.accessdb.pvrcsx". Connection may not be configured correctly or you may not have the right permissions on this connection.

    Any help regarding this problem is appreciated.:w00t:

  • May 26, 2011 at 9:46 am

    #1330453

    Unfortunately I don't have any insight into that.. Have you goggled it?

    CEWII

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

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