I built a DTS package that reads a table in the database, then imports Excel
files from a path in the table. This worked great (thanks to you all) about
1 or 2 months ago... Now I am having issues with this, I am getting the
following error,

The Microsoft Jet database engine cannot open the file
"\\SWVTC06\reports$\Employees\CreditCardLog\Logs\c roberts\'. It is already
opened exclusively by another user, or you need permission to view its data.

The Reports directory was hidden just last week (reports$), but I changed
the path to reflect this change. Also, if I paste the path into Internet
Explorer it goes to the file with no problems. SYSTEM user has full control
to the directory. Does anyone else know what may be going on?

Thanks,
Drew

Found it... stupid user error... I didn't have the complete correct path to
the excel file...

Sorry,
Drew

"Drew" <drew.laing (AT) NOswvtc (DOT) dmhmrsas.virginia.SPMgov> wrote