SQL Server's Journal (original) (raw)
10:24a - weird bcp prompt.
So because I'm an idiot, I'm rewriting those BCP commands. They all have a very similar look to them:
exec master..xp_cmdshell 'bcp "select * from edi.dbo.bgnstaging" queryout "\\server\sql data\load\bgn.txt" -Sserver -Usa -Ppassword'
I am 98% sure this bcp statement is identical to the one I lost yesterday. But there must be some very minor difference... because yesterday it worked just fine, while today I get the following output:
NULL Enter the file storage type of field recnum [int-null]:
...and that's it. Obviously, since this is in a stored procedure, I can't enter a file storage type. I can't find a single entry on the web that has this particular prompt with [int-null] after it, and nothing relating to getting rid of the prompt when writing a bcp in a stored procedure.
Anyone know how to get rid of it?