Data Transfer package for Synergy''s SDMS to sql database

• Dhaval-190627

  Old Hand

  Points: 323

  More actions

  May 5, 2005 at 3:31 pm

  #86527

  Hi !

  I am looking for some better DTS which transfer data from Synergy's SDMS database to SQL server database. We have a Synergy's business software and i am tring to find DTS package which give me better performance to transfer data from their database to sql database.

  Thanks

• philcart

  SSC-Forever

  Points: 47796

  More actions

  May 5, 2005 at 5:05 pm

  #557244

  How is the data transferred now? ODBC, OLE/DB, Linked Server, etc ...

   

  --------------------
  Colt 45 - the original point and click interface

• Dhaval-190627

  Old Hand

  Points: 323

  More actions

  May 6, 2005 at 7:24 am

  #557344

  I am using ODBC connection. It works for me 85 % but 15% of time it error out and it is very slow. Any other tool which give me better performance.