Hello,

I've an issue with a DTS. Here is the scenario:

Server side: the DTS has two step:
1) Delete some row from some tables.
2) Imports data from Access DB into SQL-Server, using a ODBC entry (from a
file)

Client side : an winforms application has two step:
1) Copy local Access DB on server
2) Run the DTS (my application reference a DTS assembly interrop).

Now, running the DTS from Server using a specific user work well. Running
the DTS from client using the same user result in an error ! (OLD DB Provider
for ODBC, ... Error Code 80004005) The first step of the DTS is done (Delete
some row from some tables). Just the second step fails !

I've tried to allocate a .log file to the pump task. Nothing is loged into
when DTS is run from client side. Everything is loged when DTS is run from
server

As the pump task take it source from the ODBC entry and that there is an
issue with it, I think that the task is even not run ! What is crazy is that
I use an ODBC file, located on c: on server (not mapped or shared folder, ...)

I'm pretty sure that ODBC entry is the problem, but I couldn't manage what
is wrong.

Any ideas ?

--
Stéphane

This error 80004005 would definitely hint that some resource cannot be found
or that you do not have permissions to log on to whatever you want to do.

Are all the DSNs etc set up?

Are you using the Access Connection object?

--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"Suedois" <Suedois (AT) discussions (DOT) microsoft.com> wrote

Thanks Allan,

I think that it isn't a permisssion to log problem, as half of the DTS work.
It mean that I could access the server, axecute the DTS, and delete values
into table (so I've permission on table).

It really seam that the DTS, launched in a specifc context, doesn't see the
access database. Bat what is really stange is that just after the error, I
could run the DTS on server and it work fine.

Any ideas ?

Stéphane
--
Stéphane


"Allan Mitchell" wrote:

So it may be my other suggestion then that it cannot find the access
database. Where is this? How are you getting there?

--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"Suedois" <Suedois (AT) discussions (DOT) microsoft.com> wrote