Using SQL to append records to a table from a flat file using DTS

Giganews Newsgroups
Subject: Using SQL to append records to a table from a flat file using DTS
Posted by:  blackd…@hotmail.com
Date: 4 Aug 2006

What I would LIKE to do is noted in the subject line. What I'm finding
is that "edit SQL" appears to only be an option if I am creating a
table. If I select "append to" the option to edit SQL shades itself as
unavailable.

The reason I'd like this is that there is a datum in the flat file that
indicates whether that record should be appended to that table noted
above. There are other ways of dealing with this "problem" but it would
be nice to be able to control it using SQL, in the DTS import/export
wizard.

If the source of my data is an SQL table, I can generate an SQL query
to specify what fields to import in an append, to check for existing
values, etc...

Is there a way around this? I can reserve a table for data transfers,
regularly overwrite it with new data from text file inputs, and use SQL
to insert select fields from that transfer table to other database
tables. (From this "transfer" table, data needs to be inserted into
four separate tables in our database).

I hope this is clear. If it CAN'T be done this way, it's okay...just a
little ugly with the need to re-create the transfer table.

Replies