a4apple (4/8/2014)
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.