I'm using a very dataflow setup in SSIS. It has one OLE DB source (remote
databse, openlink odbc driver) and one OLE DB Destination (local database).

I'm trying to grab unique data in a very conservative overlapping window.
My table has a unique key which should prevent the same data from being
imported multiple times. But the key causes the import to fail. In other
words, I'm pulling in the data many times and depending on keys to only grab
the newest records.

Each time I execute, the data is retrieved but not inserted into the local
table. I have changed "fail component" to "ignore failure" in every
location I could find. It hasn't made a difference.

What am I doing wrong?

Thanks!
Brian