Post reply

SQL Server 2005 SSIS connectivity with Sybase

  • November 19, 2007 at 4:53 am

    #121118

    Greetings!

    I want to extract data from a Sybase database using SSIS as an ETL tool, and load it to the SQL Server 2005 Data Warehouse. Please suggest me a data provider within SSIS which can be used for this, or an external vendor like Datadirect Connect 64 for SSIS and the comparison with the performance of the existing drivers and the external drivers from the vendors.

    Thanks in advance!

    Regards,

    Vivek.

  • November 19, 2007 at 2:22 pm

    #752458

    It depends on the version of Sybase. I believe there is one for versions 11 and newer. For earlier versions of Sybase, I have not found an OLE DB driver and have had to use DataReader sources and ODBC for connecting.

    If you are only reading data, this works fine. If you have to write back to the Sybase database, you need to use a script component or create a custom destination.

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

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