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