Reading data from Sybase SQL Anywhere 7 database to write into a SQL Server database


  • Hi,

    I need to import data from a Sybase SQL Anywhere vers. 7 database. This RDBMS was used more 10-12 years ago. I want to write Sybase data into a SQL Server 2008 R2-2012 database. For testing purposes I'm using SQL Server 2005.

    After that I've installed Sybase SQL Anywhere vers. 7 I can use the Adaptive Anywhere 7.0 ODBC. I'd like to use SSIS to import Sybase data, but I cannot create an OLE DB connection in a right manner while I can create and ODBC connection manager and so I can use an Execute SQL task (and not a data flow task, unfortunately!).

    Well, after using this Execute SQL task to read fe a table with thousands of data rows how can I write the entire data collection on a SQL Server table?


    • Edited by pscorca Sunday, March 30, 2014 5:04 AM
    Sunday, March 30, 2014 5:03 AM

All replies