As a final note, I've changed the two scripts from Mark and imex to read:

SELECT COUNT(DISTINCT t2.DID) (Mark's script)

AND

select COUNT(DISTINCT d.DID) (imex's script)

This gives me either no rows or a...

Yes, imex, this also does what I need. Many, many thanks!

Oh - there's a 2nd page. Sigh. Frazzled. Anyway, for anyone who hasn't gotten the message - I think Mark's solution is valid. I'm going to go bang my head...

Mark - I replied to your second script, but don't see it now. So if you got it, fine, if not, I think you're script is what I'm looking for....

Mark (sorry I called you Ten Centuries - I'm a little frazzled today) - think you're right. I think the DISTINCTs do give me what I need. I'm interested in...

Yes, that's the issue. There *shouldn't* be more than one row in Table2 with the same DID and AID, but there's no constraint against it and it could happen due...

OK, I've attached a file with DDL's for the two tables. I've dropped Table1 and Table2 and given them their real names. Same for column names. Makes it more comprehensible,...

Ten Centuries - thanks, but this is still just comparing COUNTs. I need to verify for DID = 15 not just that there are 2 rows where AID's IsStaffTask =...

Hmmm.... Thank you, but if I understand this script, it's just comparing the *number* of total AID's where IsStaffTask = 1 in both tables. I don't just want to compare...

Thanks!

It doesn't work in Bing or Google searches in IE8 or Chrome. Even when I search SQLServerCentral's Forums internally it blows up. Very weird.

It works! Thank you SO much! 😀

OK, my apologies if I'm being dense. This is my first experience with SSIS deployments. So - do I change the connection in BIDS to point to our...

So can I just include the servername of the production server where SSISConfig as another variable in my configuration? Is that what they mean?

Thanks!

OK, good to know, thank you very much!