Did you solve this? I surprised SSIS cannot do that - hoping something new came up since your question, but i'm stuck.