If the format keeps changing you can try using a Script task as Destination and you need to use a significant amount of code, I tried once.. I will try to post if I have it.

But in my case the data was coming from some stored procedure to a file. It was long back so I prefer saying I have to try again..