Hi All,

Let me start by saying I have 0, nada, zilch, zip experience with DTS, so be
gentle ;-)

We have this guy who, as part of his job, maintains an Access database, and
we need this data in an SQL Server DB. Permanently converting the Access DB
to SQL Service is not an option so I figure the best approach is this:

Once per week the guy navigates to a specific page on the intranet and
uploads the Access DB.
Then I figure I take over and use DTS to import the data into the SQL Server
DB.

So here are the questions:
1) Is this the best approach? If not what would you recommend? Are there
examples around?
2) Where can I find examples on doing the DTS in VB.NET and/or C#?

I'm also figuring the best way to sync the data is to truncate or drop the
existing tables before the import.

Comments? Suggestions? Answers?

TIA
Brian W

Looks OK to me.

Another option might be to fit an archiver to the access db whereby the
weeks work could be exported to test file and you upload the text files.
Might be smaller than the whole DB.

Examples for DTS in .Net

We have a few at www.SQLDTS.com but another great site for this is
www.SQLDEV.net


Allan


"BW" <someone (AT) somewhere (DOT) net> wrote

I have a similar situation. We have the Access drop a csv extract onto our
server and load it with dts. Job is scheduled to run daily. We will soon
change the dts process to read the Access db directly.

"BW" wrote: