Save Sql Recordset into the Flat text file?

Posted by mahesh kumar on Stack Overflow See other posts from Stack Overflow or by mahesh kumar
Published on 2009-11-09T10:59:10Z Indexed on 2010/03/24 14:03 UTC
Read the original article Hit count: 251

Filed under:

sql

|

bcp

Hi,

i need to dump my sql query result into the text file. i have created the following query,

DECLARE @cmd VARCHAR(2048) 

SET @cmd = 'OSQL -localhost -CRN370 ' 
+ ' -UCRN370 -PCRN370' 
+ ' -Q"SELECT TOP 5 GageId FROM EwQMS370..msgages"' 
+ ' -oc:\authors.txt' 
EXEC master..xp_cmdshell @cmd, NO_OUTPUT

The above query created the text file authors.txt. But the content of the file shows the following error message

" Error: Conflicting switches : -U and -E "

Any help really appreciated

© Stack Overflow or respective owner

Related posts about sql

SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

as seen on SQL Authority - Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL… >>> More
SQL SERVER – Concat Function in SQL Server – SQL Concatenation

as seen on SQL Authority - Search for 'SQL Authority'
Earlier this week, I was delivering Advanced BI training on the subject of “SQL Server 2008 R2″. I had great time delivering the session. During the session, we talked about SQL Server 2010 Denali. Suddenly one of the attendees suggested his displeasure for the product. He said, even though… >>> More
Error with SQL Server Setup 2012 on Windows 2012

as seen on Server Fault - Search for 'Server Fault'
I am trying to install SQL Server on Windows 2012. I was able to finally get the wizard up and running after making some changes on the server, but now it fails no matter what I do with the following error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: … >>> More
How can I detect which version of SQL (eg SQL 2008 or SQL Azure)

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to detect which version of SQL I am dealing with to perorm various tasks, I need specifically detect if I am on SQL 2008 or SQL Azure. How can I do this with detection code written in SQL? >>> More
Nested SQL Select statement fails on SQL Server 2000, ok on SQL Server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Here is the query: INSERT INTO @TempTable SELECT UserID, Name, Address1 = (SELECT TOP 1 [Address] FROM (SELECT TOP 1 [Address] FROM [UserAddress] ua INNER JOIN UserAddressOrder uo ON ua.UserID = uo.UserID WHERE ua.UserID = u.UserID ORDER BY uo.AddressOrder ASC) q ORDER BY AddressOrder… >>> More

Related posts about bcp

Minimum install of SQL Server 2008 required to able to run bcp

as seen on Server Fault - Search for 'Server Fault'
I need to run bcp.exe on a client machine which has no SQL Server 2008 installed. Does anyone know the minimum install options I need to select to get the bcp tool? I tried 'Client Tools Connectivity' but that didn't include it. Thanks, Jon >>> More
Master/Detail insert using BCP?

as seen on Stack Overflow - Search for 'Stack Overflow'
I've a master table with identity on for the primary key and I've some child tables. When I insert a record to the master table using BCP, how can I use the newly created ID from the master table to insert in the related child tables (May be BCP again)? Will it be possible? I may be able to set identity… >>> More
BCP task hangs while executing

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey guys, We have a HPC node that runs some of our tasks in it. I have a task in my .net project that kicks the bcp utility on the HPC node and the output of the query that I have runs into 9 Mb. When the HPC node runs this task the output of the query is dumped into a file and then after it dumps… >>> More
Run a shell command with arguments from powershell script

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I need to extract and save a some tables from a remote SQL database using bcp. I would like to write a powershell script to invoke bcp for each table and save the data. So far I have this script that creates the necessary args for bcp. However I can not figure out how to pass the args to bcp… >>> More
Can Sql Server BULK INSERT read from a named pipe/fifo?

as seen on Stack Overflow - Search for 'Stack Overflow'
Is it possible for BULK INSERT/bcp to read from a named pipe, fifo-style? That is, rather than reading from a real text file, can BULK INSERT/bcp be made to read from a named pipe which is on the write end of another process? For example: create named pipe unzip file to named pipe read from named… >>> More