Moving file to another location using "xp_cmdshell 'NET USE ....."

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  March 2, 2009 at 11:41 pm

  #97305

  Hi ,

  I want to move/copy one MDB(Ms-access) file from one location to other shared location using

  "xp_cmdshell 'NET USE ..... "

  can anybody tell how can i do it ?

  in next step : i want to encorporate it in SSIS pacakge .

  Please help me.

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• tcnolan

  SSCrazy

  Points: 2097

  More actions

  March 3, 2009 at 11:46 am

  #952631

  I have had to do this before, pretty simple. See the following...

  xp_cmdshell"net use t: \\10.10.10.10\share_name password_here /user:username_here /persistent:yes"

  /* Add extra code here... */

  xp_cmdshell"net use T: /delete"

• vijay.singh 97987

  SSC-Addicted

  Points: 495

  More actions

  November 29, 2010 at 6:07 am

  #1256202

  Thanks alot buddy:-)

  Regards,

  Vijay