How to connect to Sybase usign SSIS?

  • I need to pull data from Sybase to SQL2005.

    How can i connect to the sybase db using ssis? Which connection type should i use?

  • Hi

    You need connect throw a ODBC using the Sybase driver.

    Regards

  • Do i have to install this driver or does it come as a part of the BI?

  • Hi

    You need to install the driver, all connection to any data source that is not a SQL Server need a driver, even if you try to connect to Oracle need install the appropriated driver. So please install the driver, make a open database connection (ODBC) and then can you access Sybase with SSIS.

    Regards

  • Any clue on where can i download the driver from???

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

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