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 |
|
TopsyKretts
Starting Member
6 Posts |
 Posted - 2008-04-08 : 22:26:15
|
| I am trying to import a text file into my sql table using a dts package. But the issue I am running into is that, the text file has duplicate information in it. My primary key is working but does not allow the rest of the data to be inserted when duplicates are found.... Can any one help me with this. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-08 : 22:50:12
|
| Is it on sql2k8? You have to clean up data file, or load data to staging table first then move new rows to target table. |
 |
|
|
|
|
|
Import text file using DTS