Eliminate Duplicates while Bulk Loading

#1

Is there any way we can eliminate duplicates while bulk loading the data from a text file to a Sql server Database

Thank

Reddy

#2

You can create index on destination table with IGNORE_DUP_KEY option.

ashish

"Reddy" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Is there any way we can eliminate duplicates while bulk loading the data
from a text file to a Sql server Database.

Thanks

Reddy

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

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