How to Select Delimiter in 'Results to File'

Hot Topic

List all "ID" values in a Package
My Mobile DB.
Can't open reports or reportserver from ie
Copying database using "Copy Database"
ODBC Destination in SSIS
Execute SSIS package on vb.net
How can I restore a database from a UNC?
Query Designer in SQL 2005 Mgmt Studio a let-down?
Error using Datareader Destination
Problem in bulk insert

SQL Server

Fuzzy Lookup problems
SPIDs blocking one another with PAGELATCH_EX last wait types
Authentication Issues
Having trouble with Group by, max, etc
Conditional Split to send top 10, top20, and top 30 in three different flows ?
change column names
Errors loading a text file into a Sql Server Destination
SQL Agent Failing when trying to run my SSIS Package
Installing sql express on a sql standard server installed machine
Temporary table vs. Table Valued function

How to Select Delimiter in 'Results to File'

I want to use custom delimiters for different queries when I send the results to files. However, that choice seems to be missing from the menu in Management Studio: Tools>Options>Query Results>SQL Server.

There is a Genereal tab, Results to Grid tab & Results to Text.

What's up

Answer this question

How to Select Delimiter in 'Results to File'

  • BruceT

    Tommy -

    In SQL Server Management Studio 2005, click on Query on the menu, Results To, then Results to File.

  • Rob Thijssen

    Thank you Boris, that was exactly what I needed. I set it in the Results to Text properties and affected the file output.  I was expecting a separate settings tab for Results to File as in Query Analyzer 2000.

    This is the RTM version of SMS, 9.00.1399.00.

    Thanks again - Bil

  • san1t1

    Just checked it on My Management Studio (CTP September), as you said, on Results to Text tab, there is Output Format drop down box where you can select Custom Delimeter and then type it in the edit box below.

    Is this what you are looking for

    What version do you have

    HTH,
    Boris.

    p.s. The format you set for Result To Text will be the format saved as RPT file when you redirect results to file.

  • DanC#

    Boris

    I too am using Management Studio and I am wondering if you can help me out . Do you know how I would put my results to file so that it can be read by Excel Pivot table. I have tried but the format various methods but nothing works. Any Ideas

    Tony



  • djackowski

    I wonder how to execute the query and save 'Results to File' by sql command,
    can anyone help

  • How to Select Delimiter in 'Results to File'
Answer this question