Now this is interesting.

I moved the write of the recordset to the variable in the data flow.

Before:

OLEDB Source

Derived column transform

Data conversion transform

Multicast transform going into:

flow 1 - OLEDB Destination

flow 2 - ADO recordset destination that writes to the variable

I rearranged things so that the multicast is done after the OLEDB source, flow 1 going to the derived column and data conversion transforms, then the OLEDB Destination while flow 2 goes to the ADO recordset destination.

What happens? The ADO recordset destination turns yellow. Everything turns yellow. But nothing completes! When I stop debugging, I get the same error:

The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.

I still don't know what is going on.

[Scratch head, hurl expletives at monitor]