Not all the data needs to be imported into sql, however the data might come in one day

A1, A3, A2, A5, A8, A7

or 

A1, A2, A3, A8, A5, A7 another day

but we just need A1, A2, A3, A5.

I know that SSIS is limited in this capacity and I know Cozyroc offers a data task plus component that is not free that accomplishes this.

Any solutions? 

Hi Dickie,

What is A1, A2? I assumed these are columns.

Since SSIS relies on static metadata you need to programmatically discover it and then generate the package programmatically which defeats the purpose of using the SSIS.

Thing is, somebody wants to exchange data in un-reliable way, it typically leads to more maintenance and recovery from failures than one would imagine.