SSIS and MIMER

• Karl McIntyre

  SSC Enthusiast

  Points: 119

  More actions

  May 7, 2013 at 2:01 am

  #277228

  Hi,

  I have to copy some data on a nightly bassis from a MIMER database hosted on a UNIX platform. However as the MIMER engine is so old i can not use the ADO.Net connectors for mimer. The only way i can create a connection is VIA ODBC, but if i use the ado.net connectors for ODBC, retrieving data is painfully slow, even if i compare this to a straight forward linked server connection using OLEDB for ODBC drivers. Is there another angle I could take for this?

  Thanks,

  Karl McIntyre

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  May 8, 2013 at 10:29 am

  #1613443

  Hi Karl,

  You can use the native database tools to export your table data into CSV file. Then import the CSV file.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/