Re: DTS text file import

#1

One option would be to import the file into a staging table
and then just use an execute SQL task and write the query
using the Exists keyword. You can find documentation and
examples on using Exists in books online.

-Sue

On Mon, 18 Aug 2003 13:39:33 -0700, "wd1153"
<weimindai (AT) hotmail (DOT) com> wrote:

Quote:

hi, all

Is there any code I can use for the following purpose:

-- transferring a text file to an existing database
-- the text file may contains keys that alreay exists in
the database. If this is the case, then update the
database with the value in new textfile.

Someone once told me not to set key in the table, but set
index instead. That way, during the importing, the
duplicated tuple will be ignored for importing instead of
failing the process. While it is working, but is not what
I really looking for. Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: DTS text file import

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: DTS text file import - 08-18-2003 , 10:24 PM