Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-30 : 08:40:31
|
| Peet writes "Hi,I use Client Connection Manager to logon to the sql server on a Win 2000 plaform.I scheduled a dts package which was created on the sql2000 serverbut get the message :Error string: The Microsoft Jet database engine cannot open the file '\\130.100.??.??\CrdBData\CRdBSize.mdb'. It is already opened exclusively by another user, or you need permission to view its data. Yet it executes fine on the server from the Console. And Access is not accessing this dB, so it cannot be allready open.The job executes under the same account as I used to log onto the server.The Username on Access is Admin with no pw.This was filled in automatically by the DTS creation program, so it is reading the Access db properly.I read quite a few articles and found one on your site which gaveguidelines but did not provide the answer.Or is it still the same problem? Is the dts package in fact executing on my PC? But I do not have any sql support files on my PC(130.100.?.??)? Thanks very much for this service.RegardsPeet" |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-10-30 : 15:06:40
|
| I've had luck creating the DTS package with owner and user passwords. The 'Secure' version of the DTS package seems to behave better with permissions - particlularly when it runs manually but not from a scheduled job.I have also found that on imports, DTS leaves some locks hanging. Even after the process, I had to terminate Enterprise Manager before I could remove the import file. Whether or not this was a fluke, I don't know yet. |
 |
|
|
|
|
|
dts scheduling