Did anyone try fetching data from any database which is connected through ODBC. If so can you please share the details. In the data flow task of SSIS there is a facility for only oledb and not thru ODBC.
Connecting through ODBC
Hot Topic
- SQL 2000 Best Practices Analyzer report clarification needed.
- Chooses Cube by report parameter
- sql server 2005 error handling
- Versions of SQL Server 2005
- How to build SQL Commands in a Remote Database Component
- Adding the date to a subscription report name
- The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect
- Database Master Key Error
- SQL Server 2000 Personal Edition or Enterprise Edition
- How to restore SQL 2000 DB to SQL 2005
SQL Server
- SQL express 2005 - can not set up a database why?
- best approach
- Help! Report Model Project doesn't like my primary key
- Term Extraction
- Copy Database
- ansi padding issues 64 bit vs 32 bit
- Improving Debugging Performance
- Subscriptions & Analisys Services
- [SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe
- From DataSet To SqlDataReader in a CLR Stored Procedure
Connecting through ODBC
Murre
From what I understand, ODBC was not implemented by MS in SSIS.
See thread here
jony
Kiran05
You need to use the ODBC Provider which is a member of the ADO.Net connection types. You then need to use the DataReader source to query your database.
Larry Pope