SQL Server Performance

Export Report data into Text Format with export file extension as .txt

Discussion in 'SQL Server 2005 Reporting Services' started by SQL2000DBA, Sep 10, 2007.

  1. SQL2000DBA New Member

    Hi,
    I am using SQL Server 2005 Reporting Services. I need small help on how to export report data into text format with file extension as TXT.
    I can see Reporting services provide by default following format
    CSV (comma-delimited)
    XML
    TIFF
    PDF
    HTML
    XLS
    but i am looking for *.txt extension. I know i can save data into CSV extension but my client in interested to see txt extension when export option prompt. Please help me
    Regards
    Ravi K
  2. satya Moderator

    When you can open the report in browser why not save it as .TXT file, I know its a manual intervention but only way I can think of.
    Also you can save it as .CSV or .XLS and then use a DTS package to export it as a .txt file.
  3. dineshasanka Moderator

    or else you can use SSIS to get txt file output

Share This Page