Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS and MIMER Expand / Collapse
Author
Message
Posted Tuesday, May 7, 2013 2:01 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 7, 2013 2:23 AM
Points: 33, Visits: 98
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
Post #1450020
Posted Wednesday, May 8, 2013 10:29 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 5:27 PM
Points: 1,117, Visits: 2,219
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/

Post #1450685
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse