Post reply

SSIS import data from Sybase to SQL

  • March 27, 2012 at 8:33 am

    #253734

    Hi,

    I am trying to build a SSIS package which its data source will be Sybase and destinition will be SQL.

    Which provider for Sybase should I install and from where can I download it?

    Thanks,

    Ran.

  • March 27, 2012 at 8:51 am

    #1465027

    Most likely you will need to go to Sybase and download the appropriate OLEDB or ODBC drive for the Sybase databae you will be accessing.

  • March 28, 2012 at 1:36 am

    #1465495

    +1 on Lynn's comment.

    We had a mix of Sybase ASA and SQL, used the ASA ODBC driver to create a DSN, then used an ODBC connection manager to point to the DSN and pull the info into SQL

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

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