Tuesday, March 20, 2012

Could not set "Ignore Failure" for OLE DB Destiantion component

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