I am writing an SSIS 2005 package that reads a spreadsheet and does some ETL on it.
The L: drive on my workstation is mapped to a network drive. When I browse to that on the Excel Connection Manager it can't read the file.
I tried putting the IP address in place of the L: (\172.18.16.24\Student Records_Tech\Senior Team Rpts_Validations\Master Reference.xls) but it doesn't work.
What am I missing?