SQLTeam.com | Weblogs | Forums

Using text file as a Data set for SSRS


I need to import data from notepad(tabDelimitted) in to SSRS and display as diffrent column in the report.

I am using oledb and using the below connection String:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\RxTools;Extended Properties="text;HDR=No;FMT=Tab Delimited"

But the ouput is coming in a single Column, I need it to split to multiple columns as the notepad has many columns..

Kindly help..