Bcp in problem

• er.rajesh89

  SSC Journeyman

  Points: 96

  More actions

  April 27, 2012 at 8:25 am

  #98629

  hi

  i want insert some data from a bcp file

  so i execute a cmd:

  bcp [Meritus].[dbo].[Chennai1] in "d:\test.csv'" -N -S @@servername -T

  but it show some error:

  Msg 102, Level 15, State 1, Line 1

  Incorrect syntax near '.'.

  how to solve

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  April 27, 2012 at 9:46 am

  #1480534

  Are you executing this in a command prompt? BCP doesn't run in SSMS.

• rraja

  Default port

  Points: 1486

  More actions

  April 27, 2012 at 12:49 pm

  #1480616

  Use of BCP.

  http://msdn.microsoft.com/en-us/library/ms162802.aspx