SSIS import data from Sybase to SQL

• ran.ovadia

  Ten Centuries

  Points: 1183

  More actions

  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.

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  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.

• Ant-Green

  SSC Guru

  Points: 113536

  More actions

  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