Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 CSV file as SSRS Dataset

Author  Topic 

Nikhil1266
Starting Member

1 Post

Posted - 2010-03-27 : 11:02:06
Hi,

I would like to know how can I make a CSV file as a dataset in ssrs?
I have a cdv file which I would like to make it a source for the report. How can i make a datasource connection to the same & then make a report based on the csv file

Thanks
nikhil

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-27 : 11:09:55
you need to use distributed query like OPENROWSET for that

see

http://msdn.microsoft.com/en-us/library/ms190312.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -