Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ryanlcs
Yak Posting Veteran
62 Posts |
 Posted - 2007-07-18 : 03:03:15
|
| I have a DTS using the Transform Data Task that import date from a csv file. This import will surely import duplicate key into existing table. Then I perform a duplicate key deletion.Now I want to import the data but I dont want the duplicate data to be imported. But the column (2 column) that I dont want the duplication is not the primary key.Is there a way to prevent the duplicate key to be inserted, so I do not need to delete duplicate key to save up processing time.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-18 : 11:21:13
|
| Insert the data into a staging table then use T-SQL between the staging table and your real table to decide which rows to move.The staging table typically matches the layout of the file and not necessarily of the destination table.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
DTS Import without duplicate key