ODBC Data Flow Source

[TeamGD]

I need to extract data from tables in a database that I can only access via ODBC.

I have successfully created a connection in Connection Manager (ConnectionManagerType = ODBC) for this database.

However I’m unable to add this connection as a Data Flow Source. There is no ODBC Source option in the Toolbox.

How do I extract data from tables in a database via ODBC?

Thanks in advance

 

[Catadmin]

What type of database are you trying to extract the tables from?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[Catadmin]

BTW, I think DataReaderSource might be your ticket, but I haven't tested it yet.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[TeamGD]

Thanks Catadmin

The underlying tables are in C-ISAM

Cheers

gmhm

 

[TeamGD]

Thanks Catadmin

DataReader source does appear to be my ticket. But I’m not quite out of the woods yet.

I am successfully running a package that extracts data from a table via ODBC and loads into a table via OLEDB. To get there I added an Ado.Net connection in the Connection Manager, with the Provider set to .NetProviders\ODBC Data Provider. I then used DataReader source with the Ado.Net connection I created as its Connection Manager. I wrote a simple select statement in the SQL Command within the properties. All is working.

However I got this working in an environment where the underlying database behind the ODBC is an SQL Server 2005 database. I deliberately did this to keep things simple when testing DataReader.

I need to access C-ISAM tables via ODBC. After going through the exact steps as above, I’m getting the following error in the DataReader Source:

The column <column name> does not have a matching source column in the DataReader schema.

I have posted this problem in a new thread.

Thanks for initial direction Catadmin.

Cheers

gmhm

 

[Catadmin]

Sorry I couldn't help you out more.


Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"