I am trying to build a report off a csv file. To start with I created a data source to an ODBC connection that I had already created. Then I added a dataset using that datasource. In the preview I am able to see the fields or columns from the CSV file. I click on preview data and I am able to see the data. No issues so far. Finally I had a simple table to my report drop a few fields on the report and click run and I get an error... ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ---------------------------- Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) ---------------------------- An error has occurred during report processing. (rsProcessingAborted) I altered the connection string to... Dsn=CSVFile;Driver=Microsoft Text Driver (*.txt;*.csv);dbq=C:\Temp\CSVTest\;extensions=csv;Trusted_Connection=True; Now I get different error... ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Any idea why I am getting this report on the report when I had no issues when previewing the data. Has anyone tried this successfully? Thank you.

Hi RMehta, You mentioned " click on preview data and I am able to see the data. ", so we can conclude that your datasource connection and CSV file is correct, here I suspect you generate the query using the Query Designer, actually you should make some modification after generating the query via Query Designer , your query might be similar to below: SELECT `Report2.csv`.* FROM `Report2.csv` Actually, you should modify it to this: SELECT * FROM Report2.csv Otherwise you will receive the error information. If you have any question about the steps for creating CSV datasource, please see this thread I ever handled http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/a48d4006-6915-4511-9b17-fdafdf6016fa/ Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Thank you for your response Challen Fu. My select statement is already exactly as you have mentioned. SELECT * FROM Report2.csv

Hi RMehta, It seems your connection string is not correct, please follow these steps: 1. Click Control Panel, then select Admin Tools. 2. Click Data Sources (ODBC). 3. To add a new data source, please select Microsoft Text Driver, give it a name and select the directory storing the *.csv files. 4. When in the reporting services development tool Create a new data source and change the default from SQL Server database to ODBC. 5. Select the ODBC data source you just created. I think it then prompts you to select the actual *.csv file. Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Thank you for your input. What you are suggestion is how I started. That's when I posted my problem. I get the first error shown in my initial post.