Dear Friends,
I have to import dBASE files to SQL Server. For this I have created one ODBC connection manager for those dBASE files. This I have to set for DataReader Source. But I am unable to configure the DataReader Source.
So, Please tell me how to configure DataReader Source for ODBC connection Manager.
Eagerly waiting for your valuable reply............
Santosh
INDIA
Are you getting any error?
Once in the data reader; you should provide the query and the connection manager information.
|||Hello Santosh
Instead of creating an ODBC Connection Manager, you should create a ADO.NET Connnection Manager that uses the OdbcClient provider, and configure it to use the DSN you've set up for dBASE. I haven't tried dBASE specifically, but as a general statement the DataReader Source works only with ADO.NET connections.
-David
No comments:
Post a Comment