July 3, 2014 at 1:33 pm
I need to generate a .txt file via a SSRS report. My thought was to export the report as .xlsx then build a SSIS package to convert the file. In theory I thought this would work but I'm unsure how to implement SSIS to convert the file. Any assistance would be greatly appreciated.
Thank you!
July 3, 2014 at 2:04 pm
SSRS has a built in export to CSV. Would that work to get a text format?
July 3, 2014 at 2:27 pm
I see SSRS only exports as CSV (comma delimited) or CSV (Tab delimited), I actually need tab delimited.
July 4, 2014 at 1:24 am
Avoid Excel at all cost.
Export to CSV comma delimited and then convert it with SSIS to tab delimited.
Or just write a very small .NET app that replaces the commas with tabs.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 4, 2014 at 2:05 am
July 7, 2014 at 1:53 pm
This is exactly what I needed. Thank you so much for the info!!!
July 8, 2014 at 12:12 am
Glad to help.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply