question

Dick Rosenberg avatar image
Dick Rosenberg asked

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

ssisexcel
10 |1200 characters needed characters left characters exceeded

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

Kirti avatar image
Kirti answered

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 characters needed characters left characters exceeded

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

CirqueDeSQLeil avatar image
CirqueDeSQLeil answered

Do you get an error message?

Next on the list would be to verify permissions.

10 |1200 characters needed characters left characters exceeded

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

Fatherjack avatar image
Fatherjack answered

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

1 comment
10 |1200 characters needed characters left characters exceeded

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

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 Likes 0 ·
Jason Crider avatar image
Jason Crider answered

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 comments
10 |1200 characters needed characters left characters exceeded

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

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 Likes 0 ·
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 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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