sql server dts: Append Data to Existing table daily -- sql server dts

Append Data to Existing table daily

Matt Williamson
10/2/2007 2:00:28 PM

sql server dts:

I've been given a task and I'd like to get some feedback as to the best way
to accomplish it. I have a table that is historical data from an old system
that stays static. Everyday, I need to export a csv file from a new system
and append it to the static table for all entries after a specified date
(the day we converted to the new system). What would be the best/most
efficient way to accomplish this using DTS? I've started experimenting, but
that's really as far as I've gone. I'd like to have a good roadmap to start
off. I'm using SQL 2000 Sp4 on a Win2k3 RC2 server.

TIA

Matt

Re: Append Data to Existing table daily

Jeff Boyce
10/3/2007 1:55:07 PM

Matt

You've described a "how" (copy records out of one db and put them in
another). Now, "why?"

It sounds like you have some records that are "current" and some that are
"historical". Rather than store those in two different tables, what about
using a single table in a single db, and adding a field to note that the
record is "historical". A simple bit field would work, or you could store
the date the record became historical, if you might need to search for which
records went "historical" on, say 10/3/2007.

Regards

Jeff Boyce
Microsoft Office/Access MVP

[quoted text, click to view]