Flat File Connection which requires a password

• richard.highton

  Newbie

  Points: 1

  More actions

  November 24, 2009 at 4:08 am

  #137092

  I need to make a connection to a csv file which is located in a floder on a foreign server, and the folder in question requires a user name and password. I can map a drive to this folder and my package runs, but my problem is that of running the package overnight via an SQL job and the drive not being mapped.

  Does anyone know if I can get round this problem?

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  November 24, 2009 at 5:51 am

  #1083388

  Use a UNC path to get round the unmapped drive issue.

  Ensure that the SQL Agent service user is a domain user which has at least read access to the folder on the 'foreign' server and all should be well.

  ---