I can add that SSIS is extendable. Thus it is possible to create in .NET your very own data source component for the data flow task to adapt to files in non standard formats. To do this well seems to me complicated but there may already be someone that has. I'm sure that is what CozyRoc is pointing to.