Asked by:

KSAM data integration advice

Question

I have to retrieve data from a KSAM (kerridge) database and can only use a file dsn ODBC connection to connect to the database.

I can get access to the database through excel and thereby see the tables but when I try and open a connection through the development environment, it keeps my machine busy for what seems to be an eternity whith no result.

I want to use SSIS to extract the data to a SQL 2005 database but will need to get my connections/connection managers to work.

Is there any advice that anyone can give me on perhaps the best approach on the data extract?RegardsMike