Thanks Craig. I'll be looking at this later tonight and most of the day tomorrow. I appreciate your insight.

Thanks for all your input.

Craig, in your opinion could I use the Lookup or Merge Join transforms to compare between the source and the target? If so, which one...

Got the CHECKSUM issue taken care of and it appears to be working correctly now. I will probably try and use that to indicate if data needs to be...

We have been told by the vendor of the software that runs on the databse that they don't support rowversion. Evidently they have a number of procedures in their...

Thanks guys! You can do either. You can fully qualify it in the @query parameter or don't do it there and use the @execute_query_database. I don't know...

Elliot,

Thanks for your ideas. I ended up just using the SP in a data flow and then pushing the row count to a SSIS variable and then used the...

Thanks

I haven't done a lot of this before but sounds like it will work. I'm going to start trying to do it and I'll see where it goes.

They don't need to go anywhere really. Probably just put them in the email notification. When I say put them in the notification it is as simple as...

If this first SP returns any records then we know we need to do some checking to see if it is good/bad. This is and will have to be...

Greg,

No need to apologize. Thank you for all of your help. Works like a charm with the test data. I added more fields to match on and...

Thanks for the input guys. I was working on another issue today and just came out and looked to see if any posts had been made. (I didn't...

Thanks Phil. Based on your instructions I was able to get it to work. Thanks again.

I think a variation of your second suggestion will work. Basically, from that suggestion I was able to get the solution I had previously posted.

Kind of embarassing. It...

Lee, I'm not finding the series you are referring to. Could you provide a link? I'd like to check it out.

I also think that I have something...