So after testing and reviewing my requirements, implementing the solution via SSIS was easier for me. There wasn't a big preformance difference when I processed 10,000 records, but the...

Yes and Yes. I am able...

Hi Jack and Lowell,

I'm not bound to using SSIS. Would I get better performance using Lowell's solution? I have about 10,000 records in my table 1 that...

Thank you Jack and Lowell so much for taking the time to respond. I really appreciate it.

I'm going to try incorporating Jack's solution into my package. ...

Hi Jack,

Sorry I should've mentioned that. Yes, both tables are in the same database.

I've finally found the solution.

I found a thread talking about a similar problem: Here

And here was the solution I followed which works like a charm, I'm a big fan...

Hi Andy,

Did you eventually get the answer to your question? I am looking to do something very similar and would really appreciate some tips if you got yours working.

Thank...

Hi Jack,

Thank you for the article. It was very helpful and has enabled me to weed out the bad records so far.