How to use CSV file as Data Source in SSRS Report - SQL Server Reporting Services(SSRS)

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.


Solution:

Here is step by step solution.

Step 1: Create the DSN entry
Go to Control Panel -- Administrative Tools and then click Setup ODBC data sources(32-bit)
Step 2:
Create DSN Entry as shown below


Step 3:Choose the Directory in which your CSV file will be


 Step 4: Open SSDT and create new Report
Open SQL Server Data Tools and create new report. Go to Data Source and create Data Source by using DSN entry we have created.

Step 5:
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.





4 comments:

  1. Why we should choose 32 bit instead of 64 bit ODBC?

    ReplyDelete
  2. Individual data must be precise and, where vital, stayed up with the latest
    ccanadianonline1

    ReplyDelete
  3. Pasarqq tempat Bermain judi bandarq online tentunya menjadi di antara pilihan yang tidak sedikit dipilih oleh pemain website bandarq .Bisa anda lihat profile terkait pasarqq ternama melalui metode klik link https://findery.com/pasarqq , lalu https://www.thebaynet.com/profile/noverakasanti888 kemudian https://fontlibrary.org/en/member/pasarqq/ dan juga http://www.myfolio.com/pasarqq.
    Selain itu juga pasarqq ini memiliki homepage personal seperti https://pasarqq.cabanova.com/
    http://rebuildingtogethernb.org/selamat-datang-di-situs-poker-online-pasarqq/
    http://sonidoslibertarios.org/selamat-datang-di-situs-poker-online-pasarqq/
    http://jonnymugwump.com/selamat-datang-di-situs-poker-online-pasarqq/

    ReplyDelete