| Author |
DTS Across Network Errors
|
|
| michael.esposito@gmail.com 2006-03-10, 11:23 am |
| I have a database and web server (physically different boxes) and I am
trying to get DTS to read in a file from the web server and insert the
data into the database. I get permissions errors when I try to execute
the job, so I am thinking if I could some how get the file over from
the web server on to the database server, then it would run fine.
This is a job, and it will happen every day.
Any suggestions would be very appreciated.
| |
| Paul Zanbaka 2006-03-10, 1:23 pm |
| Check your security on that folder
If anything write a batch file that brings the file to you server
Schedule to run before DTS
--
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"michael.esposito@gmail.com" wrote:
> I have a database and web server (physically different boxes) and I am
> trying to get DTS to read in a file from the web server and insert the
> data into the database. I get permissions errors when I try to execute
> the job, so I am thinking if I could some how get the file over from
> the web server on to the database server, then it would run fine.
>
> This is a job, and it will happen every day.
>
> Any suggestions would be very appreciated.
>
>
| |
| michael.esposito@gmail.com 2006-03-10, 1:23 pm |
| Mr. Sanbaka,
Here is the exact error I am getting...maybe this can help. I gave
Everyone full rights to the folder and it still doesnt work right.
Should I try creating a batch file to copy it to the DB server?
Error string: The Microsoft Jet database engine cannot open the file
'\\abc123\d$\mdb\WVL
2000Mike.mdb'. It is already opened exclusively by
another user, or you need permission to view its data. Error
source: Microsoft JET Database Engine Help file:... Process Exit
Code 7. The step failed.
| |
| Paul Zanbaka 2006-03-10, 1:23 pm |
| Michael
Make sure the databsae is not open by a user at the time DTS is trying to
access it.
If you were to use a batch file yes copy it to the server
--
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"michael.esposito@gmail.com" wrote:
> Mr. Sanbaka,
>
> Here is the exact error I am getting...maybe this can help. I gave
> Everyone full rights to the folder and it still doesnt work right.
> Should I try creating a batch file to copy it to the DB server?
>
> Error string: The Microsoft Jet database engine cannot open the file
> '\\abc123\d$\mdb\WVL
2000Mike.mdb'. It is already opened exclusively by
> another user, or you need permission to view its data. Error
> source: Microsoft JET Database Engine Help file:... Process Exit
> Code 7. The step failed.
>
>
| |
| michael.esposito@gmail.com 2006-03-10, 1:23 pm |
| Thats the problem I am having, I get permissions errors when I try to
use a batch file to move it over
|
|
|
|