Can SQL Server Reporting Services query a .csv file to use as report data?
Can SQL Server Reporting Services query a .csv file to use as report data?

Software/Hardware used:
ASKED: April 3, 2008  7:59 PM
UPDATED: April 4, 2008  9:20 AM

Answer Wiki:
I'm not 100% sure if it is possible to do that but if not, you could always use SSIS to import the CSV file into SQL Server (new database / new table(s)) and then query that using Reporting Services - might be more efficient anyway depending on what your exact requirement for this are Simon
Last Wiki Answer Submitted:  April 4, 2008  9:20 am  by  Canary81   30 pts.
All Answer Wiki Contributors:  Canary81   30 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _