This is a validation error, not an execution error. To avoid the validation error and have the error thrown at execution time, try setting the Excel connection's DelayValidation property to...

In the absence of any description of selection logic which needs to be applied, this is the best I could do.

SELECT *
FROM #Data d
WHERE d.AID = 70

You've been in the industry for a long time, so I very much doubt that you'll provide answers which will make you look at all bad. Before clicking on POST,...

I assume that this is not a read-only copy of SFDC data, otherwise I see no reason to bother ... the FKs have already been enforced in the source system.

You mention the word 'upgrade' in the message's subject. What is being upgraded here?

You sore about not being in the Top 100, Des? 🙂
Notice how the column is titled 'Score', rather than 'Posts'. There is more going on here than just posts.

There is also stuff like this 

DTS:CreationDate="2/17/2016 10:19:04 AM"
DTS:CreatorComputerName="Brad"
DTS:CreatorName="Wile E Coyote"

Which I'm not sure can be modified through the GUI, though...