BCP Utility

• pzalkikar

  Old Hand

  Points: 371

  More actions

  March 10, 2004 at 5:57 am

  #160641

  Hello Everybody

  I want to use bcp command line utility. I have one server where IIS is installed. No sql server or sql client is installed is installed on this m/c. But I need to use bcp from this server. How can this possible. Is there any way to install only bcp utility (only command line utilities) ?

  Thanx in advance

  Waiting for reply

  Prakash Z

   

• ButchH

  Ten Centuries

  Points: 1073

  More actions

  March 10, 2004 at 11:19 pm

  #498212

  All you really need to do is invoke the BCP utility from your SQL server using a complete path like: 

  \\server\path\bcp <switches> <files>

  Or map a drive to the SQL server and use:

  <drive>:\path\bcp <switches> <files>

  Hope this helps.

  I forgot... you MAY need to create a (ReadOnly?) share to the folder where BCP lives.

  
  Butch