BCP in TSQL

• amit.sinha-717308

  SSC-Addicted

  Points: 408

  More actions

  August 29, 2008 at 9:30 am

  #211916

  Hi,

  I am using following code for data transfer to flat file:

  declare @sql varchar(8000)

  select @sql = 'bcp demo.scheme.test3 out c:\test20.txt -T -c -t,'

  select @sql

  exec master..xp_cmdshell @sql

  it works fine. However when I change comma seprator to pipe

  declare @sql varchar(8000)

  select @sql = 'bcp demo.scheme.test3 out c:\test20.txt -T -c -t|'

  select @sql

  exec master..xp_cmdshell @sql

  it throws an error:

  The syntax of the command is incorrect.

  Any idea why?

• amit.sinha-717308

  SSC-Addicted

  Points: 408

  More actions

  August 29, 2008 at 10:07 am

  #865135

  I wanted pipe to use pipe as field delimiter instead of comma. However I found the answer. It should be:

  declare @sql varchar(8000)

  select @sql = 'bcp demo.scheme.test4 out c:\test21.txt -T -c -t"|"'

  select @sql

  exec master..xp_cmdshell @sql

  and it runs fine.

  Thanks