InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 16:51:27 GMT20http://www.sqlservercentral.com/Forums/Topic1167602-338-1.aspxThank Lowell! After an entire day of troubleshooting, your answer finally helped us solve the issue! :-)Wed, 13 Feb 2013 15:42:00 GMTkmclinhttp://www.sqlservercentral.com/Forums/Topic1167602-338-1.aspxThanks Lowell, your answer has helped me too.Fri, 20 Apr 2012 03:28:45 GMTJohn Olynn-373146http://www.sqlservercentral.com/Forums/Topic1167602-338-1.aspxGot it. Someone had changed the Server. It is a dev box. the Production box is fine. All is well.Thank You Lowell!Tue, 30 Aug 2011 13:11:53 GMTCharlie-551146http://www.sqlservercentral.com/Forums/Topic1167602-338-1.aspx[quote][b]Charlie-551146 (8/30/2011)[/b][hr]No Sybase installed.[/quote]Charlie don't hate me, i'm just the messenger, but that is defintiely the context menu from SyBase's bcp /?[url]http://manuals.sybase.com/onlinebooks/group-as/asg1250e/util/@Generic__BookTextView/10086;pt=10086[/url]try changing the path to bcp to explicitly go to teh microsoft folder, or edit your PATH environments to exclude the Sybase directory(on the server running xp_cmdshell....not your local box, unless they are the same machine).Tue, 30 Aug 2011 12:34:29 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1167602-338-1.aspxNo Sybase installed.Tue, 30 Aug 2011 12:17:55 GMTCharlie-551146http://www.sqlservercentral.com/Forums/Topic1167602-338-1.aspx[quote][:slice_number[/quote]THAT makes me thing you are calling the SyBase bcp.exe and Not the SQL Server's version. SQl doesn't have a slice.do you have SyBase client tools installed?if you change the command to" C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\bcp.exe, does it work then?Tue, 30 Aug 2011 10:56:34 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1167602-338-1.aspxThanks Lowell,I changed the query to read like this:DECLARE @Filename VARCHAR(100)DECLARE @SQL VARCHAR(4000)SET @Filename = 'C:\Event.xml'SET @SQL = 'EXEC AllEvents.dbo.USP_EventXML'SET @SQL= 'bcp "' + @SQL +'" queryout ' + @filename + ' -w -r "" -Uce672992 -PNot_Real -SSITW2K3SPA03 ' PRINT @SQLEXEC Master..xp_CmdShell @SQLNow I'm getting a syntax error in queryout Copy direction must be either 'in' or 'out'.Syntax Error in 'queryout'.usage: bcp [[database_name.]owner.]table_name[:slice_number] {in | out} datafile [-m maxerrors] [-f formatfile] [-e errfile] [-F firstrow] [-L lastrow] [-b batchsize] [-n] [-c] [-t field_terminator] [-r row_terminator] [-U username] [-P password] [-I interfaces_file] [-S server] [-a display_charset] [-q datafile_charset] [-z language] [-v] [-A packet size] [-J client character set] [-T text or image size] [-E] [-g id_start_value] [-N] [-X] [-M LabelName LabelValue] [-labeled] [-K keytab_file] [-R remote_server_principal] [-V [security_options]] [-Z security_mechanism] [-Q]NULLTue, 30 Aug 2011 10:42:27 GMTCharlie-551146http://www.sqlservercentral.com/Forums/Topic1167602-338-1.aspxCharlie I only see two things.i think the call to the procedure has to be fully qualified, i always put the servername.schemaname, but that might not be an issue.the other thing i see that doesn't match my examples, is where i expect the -r or -t row and field terminators to be in [b]double [/b]quotes...yours doesn't look like it did (i know the forum strips slahs-n unless you htmlize it)...but i'd expect the dbl quotes.i just tested the example below, and it works fine.[code]DECLARE @sql varchar(2000),@filename varchar(200)SET @sql = 'EXEC Sandbox.dbo.sp_find ''act'' 'set @filename = 'c:\data\myfile.xml '--put it all together--flags -w wide format--t custom field terminator--r custom row terminator--U username--Ppassword--S serverSET @sql = 'bcp "' + @sql + '" queryout "' + @filename + '" -w -t"|" -r"\n" -Ulowell -PNotTheRealPassword -SDEV223'EXEC Master..xp_CmdShell @SQL[/code]Tue, 30 Aug 2011 09:52:44 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1167602-338-1.aspxI am trying to run the following statement, but get errors. Any help would be appreciated.DECLARE @SQL VARCHAR(4000)SET @SQL= 'bcp "exec USP_EventXML" queryout c:\myfile.xml -w -r -t -S <servername removed> -U <loginid removed> -P <password removed>' EXEC Master..xp_CmdShell @SQLThis is supposed to write an XML file of the table contents to c:\myfile.xml Errors are:Copy direction must be either 'in' or 'out'.Syntax Error in 'queryout'.usage: bcp [[database_name.]owner.]table_name[:slice_number] {in | out} datafile [-m maxerrors] [-f formatfile] [-e errfile] [-F firstrow] [-L lastrow] [-b batchsize] [-n] [-c] [-t field_terminator] [-r row_terminator] [-U username] [-P password] [-I interfaces_file] [-S server] [-a display_charset] [-q datafile_charset] [-z language] [-v] [-A packet size] [-J client character set] [-T text or image size] [-E] [-g id_start_value] [-N] [-X] [-M LabelName LabelValue] [-labeled] [-K keytab_file] [-R remote_server_principal] [-V [security_options]] [-Z security_mechanism] [-Q]NULLThank You,CharlieTue, 30 Aug 2011 09:05:14 GMTCharlie-551146