How to change the server name dynamically in the BCP

• sandy-452768

  SSC Veteran

  Points: 225

  More actions

  July 3, 2007 at 1:29 pm

  #177325

  DW.dbo.orders out \\SQLD003\Mart\Backup\NewChanges\orders.bcp -c -m1 -S SQLD003 -T

  here the table orders data is stored through BCP in the shared folder

  \\SQLD003\Mart\Backup\NewChanges\orders.bcp    sqlD003 is the drive and the same server is passed as the parameter for the bcp as -S SQLD003

  So my question is how to change the server names dynamically in the QA and PROD, I am using this in the execute process task.

   

   

   

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  July 4, 2007 at 2:58 am

  #717092

  Just replace the server name with [local] or . so that it will point to  the current database server. in your case it might be a QA or PROD server.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com