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 |
|
JamesT
Yak Posting Veteran
97 Posts |
 Posted - 2002-05-30 : 13:31:00
|
| I have an Ignore Duplicate index on a table where I load data into for processing. When it ignores duplicates it reports an error for the DTS Transformation. I don't want it to do that because it is not an error in the context in which I am using it. How can I prevent this from reporting an error?Thanks in advance. |
|
|
dataphile
Yak Posting Veteran
71 Posts |
Posted - 2002-06-03 : 08:17:41
|
| If you are going to violate a constraint you might as well remove it.Otherwise uncheck the "Check constraints" box in the data transformation task. |
 |
|
|
|
|
|
DTS Error with Ignore Dups Index