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

Jun Fan

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!

Philippe

About the table, did you set any unique (or clustered) index on it

Philippe

Andy Leonard

Hi Jun,

   Setting Ignore Failure doesn't cover all bases. As Philippe alludes to, you cannot violate a Unique constraint.

Hope this helps,
Andy

Jun Fan

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