Hello !

I have a DTS on my SQL 7 Server, which import data from an
Access database (mdb) into the local server..

I can run this DTS manuall on the server and it works
fine..

I set it up as a Scheduled task to run every 10 minutes,
but it always fails and returns this msg..

.... DTSRun: Executing... DTSRun OnStart:
DTSStep_DTSDataPumpTask_1 DTSRun OnError:
DTSStep_DTSDataPumpTask_1, Error = -2147008507
(80074005) Error string: Unspecified error
Error source: Microsoft Data Transformation Services
(DTS) Package Help file: sqldts.hlp Help
context: 1100 Error Detail Records: Error: -
2147008507 (80074005); Provider Error: 0 (0) Error
string: Unspecified error Error source:
Microsoft Data Transformation Services (DTS) Package
Help file: sqldts.hlp Help context: 1100
Error: -2147467259 (80004005); Provider Error: -
534709256 (E020FBF8) Error string: The Microsoft Jet
database engine cannot open the
file '\\Server\Data\Logs.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: Help context: 5003051
DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 D...
Process Exit Code 1. The step failed.

The server acount has full access to the folder and dmb
file..

Does any body know what the problem is ?

Thanks in advantage,


Tonny

In message <06a801c3d47a$287d8840$a001280a (AT) phx (DOT) gbl>, Tonny
<tonny (AT) discussions (DOT) microsoft.com> writes
Have you read this article-
http://support.microsoft.com/?id269074

Does the SQL Server Agent service or Proxy Account have access to the
UNC share? Which account is being used?


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Hello Darren..

I can't check your reply msg.. It says: Message Unavailable

Could you please write it again ?

Thanks

Tonny
-----

In case Darren doesn't get to answer you and you need it

Have you read this article-
http://support.microsoft.com/?id269074

Does the SQL Server Agent service or Proxy Account have access to the
UNC share? Which account is being used?


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Tonny" <aarmentac (AT) QUITyahoo (DOT) com.mx> wrote

Hi Allan..

SQL Server Agent is using System Account and the SQLServer
connection Use Win NT Autentication..

the NT Account is a member of the Administrators Group..
even I also added it to the security List..

but, it's the same thing: ...Microsoft Jet database
engine cannot open....

The system account cannot see past it's own disk drives so if the Access DB
is not local then you are scuppered. Jobs use the Agent account

http://support.microsoft.com/?kbid=269074


--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Tonny" <aarmentac (AT) QUITyahoo (DOT) com.mx> wrote

Thank you very much Allan..

The acount that starts the Agent service is the (most
important) detail I was missing..


Tonny
-----