I've all but given up on the OLE DB Command transformation. I've switched to stage tables and stored procedures. The data flows in the majority of my packages are simply to get the data to the stage table where I can use other processes to do my magic.

This assumes that you have a place to put the data on the destination server so you can run all the T-SQL you need to do the work.