How to Configure DSN with DataReader Source

Hi
I am not able configure DSN in SSIS, I tired with DataReader Source but its given error
" Check SQL Command Property"
Appriciate to you for Help

Errr....try checking the SQLCommand property. What is it set to?
What is a DSN in SSIS?

You have to provide more specific info if you really want people to help.

-Jamie|||

Hi Jamie

I made one DSN which pointing Excel Driver, But when Create Connection Manager for these DSN by using ADO.NET Connection Manager.
When i configure this connection manager in DataReader Source its give as error "check SQL Command property"
Here I am ot able to set SQL Commmand property
so please Help me to set the property with any example

|||If you are connecting to Excel, why give yourself the added grief of maintaining an external DSN? Use the OLE DB Provider for Jet and a file path. ODBC simply adds one more unnecessary layer of DLLs in the background.

-Doug|||Thanks Doug
I got it from OLE DB,Thanks again for your help

How to configure DataReader Source for DataFlow

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

How to configure DataReader Source for DataFlow

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