MS SQL Server DTS - DTS Package has become broken.

Author

DTS Package has become broken.

Drew

2005-07-19, 11:23 am

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$\E
mployees\CreditCardL
og\Logs\croberts\'. 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

Drew

2005-07-19, 11:23 am

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

Sorry,
Drew

"Drew" <drew.laing@NOswvtc.dmhmrsas.virginia.SPMgov> wrote in message
news:OTNhoCIjFHA.3608@TK2MSFTNGP12.phx.gbl...
>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$\E
mployees\CreditCardL
og\Logs\croberts'. 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
>

Sponsored Links