I am using Microsoft SQL Server Integration Services Designer
Version 9.00.1399.00.
My OLE DB Destiantion component is inserting data into a table. When there is duplicate it will failed. But I want ignore this since I know data is same. But even I set Ignore Failure from OLE DB Destioantion Editor. It will not work and every time you reopen editor, the buttom drop down box always showing as " Fail componet". When I try run it, it will always fail on the inserting duplicated rows.
Does anyone know how can I tell servies ignore this error.
Thanks!
About the table, did you set any unique (or clustered) index on it?
Philippe
|||Hi Jun,
Setting Ignore Failure doesn't cover all bases. As Philippe alludes to, you cannot violate a Unique constraint.
Hope this helps,
Andy
Yes. I do have unique constraint on that table. But what kind failure it will ignore?
By the way, I get this work around by add aggregate function before. Thanks for the help!
Jun Fan
No comments:
Post a Comment