Scenario:Let's say we are working with Asset under Management company, they would like to get rating everyday from different companies such as Bloomberg etc. in csv file. We should like to read data from the csv file and display for our users in SSRS Report.
Go to Data Set and create DataSet by using below Query
Select * From yourfilename.csv
If you like you can add where clause as well. After writing your query, you will see the fields and will be able to use them in your report.