UNC vs Local Drive Letter in source

• Rob DeMotsis

  Ten Centuries

  Points: 1313

  More actions

  June 19, 2003 at 3:23 pm

  #105877

  Does anyone have experience in the performance gained or lost when using a UNC instead of a drive letter in the path of the source file?

  Rob DeMotsis

  Sr. SQL Server DBA

  
  Rob DeMotsis
  Sr. SQL Server DBA

• June 23, 2003 at 8:00 am

  This was removed by the editor as SPAM

• jfb

  SSCrazy

  Points: 2469

  More actions

  June 23, 2003 at 10:56 am

  #462666

  Nope...

  What is the problem?

  In DTS is better to use UNC path, specialty if you want to schedule as job later.

  Make sure you have permission on the network.

  JFB

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  June 24, 2003 at 12:37 am

  #462733

  Hi Rob,

  I decided to use UNC when our network admins decided to disconnect mapped drives via login script. Saves a lot of frustation

  Cheers,

  Frank

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]