Data Import from Sybase -> SQL Server 2005

• Ahmet Akin

  SSC-Addicted

  Points: 401

  More actions

  May 14, 2009 at 10:39 am

  #209310

  Hi @ll,

  I need your help!

  we are trying to import large data ( approx. 19 million data sets) from a sybase table into a SQL Server database with the Integration Services via Sybase driver (OLE DB). (registered drivers : dboledb10.dll and

  dboledba10.dll ; SQL Server Enterprise Edit. X64; Windows Server 2003)

  The packages works fine und results successfully, but it imports data sets between 7-9 Million rows....instead of 19 million rows.

  We also tried it with a data import in SQL Server (-> linked server; and then with OPENQUERY), the import finishes successfully but the result delivers again between 7-9 Million rows. The amount of rows which is delivered through the import is varying;

  Has anyone experienced such a problem with Sybase? Or can anyone tell me an other way to import the 19 million rows? I do not want to import them via flatfile.

  My problem is: I do not get all the data rows i need....i need 19 million and i just get rows between 7-9 millions....any ideas?

  Thanks in Advance

  Ahmet

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  May 14, 2009 at 10:44 am

  #994705

  Please don't double post, it just fragments any responses you may get.

  Please reply here.