We have a C-Tree Database from Faircom.
I am able to connect the database through their ODBC Drivers. I am trying to import the data from C-Tree Database to SQL 2008.
At present, how i am working is ..! I am able to connect MS Access 2007 - Using External ODBC Drivers - I am connecting to C-Tree Database.
Then from MS Access 2007, i am importing records to SQL 2008 using SSIS.
This is actually 2 steps and it is a disconnected architecture.
We want Import to be connected mode and directly from C-Tree Database to SQL 2008.
( Or )
How to import record to SQL 2008 Database through ODBC Drivers?