SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Convert .xlsx to .txt
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jstikal
Starting Member

15 Posts

Posted - 07/03/2014 :  15:27:51  Show Profile  Reply with Quote
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!

Edited by - jstikal on 07/03/2014 15:29:35

tkizer
Almighty SQL Goddess

USA
36787 Posts

Posted - 07/03/2014 :  15:35:42  Show Profile  Visit tkizer's Homepage  Reply with Quote
SSRS supports csv files, right? Csv files can be opened as text files.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jstikal
Starting Member

15 Posts

Posted - 07/03/2014 :  16:28:00  Show Profile  Reply with Quote
I see SSRS only exports as CSV (comma delimited) or CSV (Tab delimited), I actually need tab delimited.



quote:
Originally posted by tkizer

SSRS supports csv files, right? Csv files can be opened as text files.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36787 Posts

Posted - 07/03/2014 :  16:34:06  Show Profile  Visit tkizer's Homepage  Reply with Quote
But it supports that?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jstikal
Starting Member

15 Posts

Posted - 07/03/2014 :  17:12:08  Show Profile  Reply with Quote
Apologies, I must have missed something. Here are the available file options in the SSRS subscription:

XML
CSV(comma delimited)
PDF
Excel 2003
Excel
TIFF
Word
CSV(pipe delimited)

quote:
Originally posted by tkizer

But it supports that?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36787 Posts

Posted - 07/05/2014 :  16:49:53  Show Profile  Visit tkizer's Homepage  Reply with Quote
Ah, you said it support tab delimited and that you wanted tab delimited. I didn't have an SSRS available to verify. I don't have a solution via SSRS, but you can achieve the same via other methods, such as SSIS, bcp, etc.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jstikal
Starting Member

15 Posts

Posted - 07/07/2014 :  15:55:46  Show Profile  Reply with Quote
Hello Tara,

Thank you so much for the help. I used the following as the resolution.

http://seanmkrause.com/2012/10/09/sql-server-2008-r2-tab-exports/

Thank you for your time!!

quote:
Originally posted by tkizer

Ah, you said it support tab delimited and that you wanted tab delimited. I didn't have an SSRS available to verify. I don't have a solution via SSRS, but you can achieve the same via other methods, such as SSIS, bcp, etc.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000