BCP job on remote server.

• EasyBoy

  SSCertifiable

  Points: 5301

  More actions

  February 11, 2019 at 11:36 am

  #381406

  We have a requirement to delete rows from table based on specific condition on remote server.
  Let's assume we have two server A and B.

  1) Delete rows from table on Server B.
  2) Export file using bcp from Server A to Server B through SQL Agent job.

  Can anyone please help me with Step 2? How do i setup SQL Agent job using bcp?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734449

  More actions

  February 11, 2019 at 2:54 pm

  #2021727

  bcp is a command line tool, so use a command line step