Problem Reading Excel File on a Network Drive

Question

question

Dick Rosenberg asked Feb 24, '10

Problem Reading Excel File on a Network Drive

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?

Thanks,

Dick

ssis excel

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-02-25T06:50:22Z

Kirti answered Feb 25, '10

Provide full rights on L: (\172.18.16.24\Student Records_Tech\Senior Team Rpts_Validations folder

to your Srever sytem + server windows login

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2010-02-24T19:46:16Z

CirqueDeSQLeil answered Feb 24, '10

Do you get an error message?

Next on the list would be to verify permissions.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 3 · 2010-02-24T20:57:46Z

Fatherjack answered Feb 24, '10

a network location usually needs two leading slashes eg "\\172.18.16.24\ ..."

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ commented · Feb 25, 2010 at 12:33 AM

I've seen other UNC style paths lose a slash on the site, as well. I wonder if it's interpreted as an escape character in certain contexts?

0 ·

Answer 4 · 2010-02-27T20:06:56Z

Jason Crider answered Feb 27, '10

Have you checked to see if the file is read only?

Are you on x64 by chance? If so, you have to handle excel files a little differently.

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Dick Rosenberg commented · Mar 01, 2010 at 11:15 AM

The file is not read only (plus I'm only reading it) I don't think I'm on x64, but how do I tell? Dick

0 ·

Jason Crider commented · Mar 03, 2010 at 11:46 AM

I would start with the Operating system. If you have a Program Files Folder and a Program Files(x86) folder on your C: or D: drive (those are the most common), then you are running a 64-bit OS.

0 ·

question