Using SQLSever 2K, can I create a DTS package that can export the contents
of a SQLServer table into the contents of a local MDB that is constantly in
use by a local app?

The local app has an import data feature but I've been asked to try to
automate that process instead of having someone have to step through the
import procedure everyday. My DTS package works perfectly if I close down
the app, run the package and then reopen the app. It would be MUCH better
if there was some way to get around the LDB locking though.

Jeff

Can you schedule this DTS package during less traffic hours when the
application is not used at all.
--
-----------------
Satya SKJ
Visit http://www.sql-server-performance.com for tips and articles on
Performance topic.


"Jeff Swanberg" wrote:

Therein lies the problem. The app is running (and, unfortunately, not as a
service) 24/7 on a machine in our server room. Hence the reason why I've
been tasked with automating the procedure so no one has to go into the room
to perform manual imports.

So the app is constantly active. I'm looking for a way to import into one
table in the MDB while it is still running but I don't know if that's
possible.

js