Bulk insert on remote server

• rami sass

  SSC Journeyman

  Points: 75

  More actions

  September 11, 2005 at 7:16 am

  #87632

  Hi All,

  I'm trying to write an application which bulk inserts data to a remote server without involving the user. is there a way to bulk insert a local file to the remote machine without opening a shared foleder on the local machine?

• raj-247939

  SSCertifiable

  Points: 5999

  More actions

  September 13, 2005 at 8:21 pm

  #589583

  Hi  ,

   

  u can use DTS package bulk insert task.

  Create a sql server connection giving a sever name where u want to insert the data from bcp file and then select the bulk insert task.

  hope this help u.

   

  from

  killer