Posted by blackd77 on 08/04/06 20:04

This system is running MS SQL server 2000.


black...@hotmail.com wrote:
> 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.

[Back to original message]