SSIS and MIMER

  • 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

  • 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/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply