|
Home > Archive > MS SQL Server DTS > March 2006 > Exporting into open MDB
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Exporting into open MDB
|
|
| Jeff Swanberg 2006-03-28, 8:27 pm |
| 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
| |
| Satya SKJ 2006-03-29, 7:31 am |
| 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:
> 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
>
>
>
| |
| Jeff Swanberg 2006-03-29, 11:29 am |
| 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
> Can you schedule this DTS package during less traffic hours when the
> application is not used at all.
> --
|
|
|
|
|