Hi.I am trying to extract data from an intersystems cache database into a sql server database for storage and reporting purposes, on behalf of my company. I have not succeeded so far for the last couple of months as it keeps bringing back far more than the expected number of rows, and is inconsistent with the number of records returned from the same query.
I also tried extracting the data into access with the hope of getting it into sql server via access but this has not been successful either as i kept getting odbc error messages.I was able to link to the cache table from access, but could not import data into access.
I later realised that the cache database table being queried is actually a view and not a table and was wondering if this may be the cause of the problem.
Can you kindly advise on the best way of extracting data into SQL server from a cache odbc database?
Many thanks for your help.
January 17, 2006 6:58 AM
May 31, 2011 9:52 AM