Bulk Insert Source Files

• JM-92548

  Ten Centuries

  Points: 1108

  More actions

  June 17, 2005 at 9:44 am

  #164978

  Im trying to create a BULK insert using a mapped drive.

  Except that with the BULK insert at the Source data file step it wont let me pick from my mapped drive.

  It looks like it wants only files from the C:\ drive.

  How can I get to a mapped drive using a bulk insert

   

• Vasc

  SSCarpal Tunnel

  Points: 4643

  More actions

  June 17, 2005 at 2:26 pm

  #566557

  try to put UNC path and make sure that the account under wich SQL is started has access to you shared folder

  ---

  Kindest Regards,

  Vasc