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..
I think you mean a script component. If not, please expand on what you mean.
This can be done using an asynchronous script component as source (not destination - destination is the table where the data needs to be inserted) and it's not that much code.
The 'asynchronous' bit refers to the fact that the number of rows coming out of the component is different from what goes in.
Each row of the file should be read as a single string and then parsed in the script.
You will find examples if you search for them, or I can provide more input if you decide to change how you are doing things.
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.