OPENROWSET Bulk insert Text File NULL Columns
Ended up using a combination of Power Shell and SQL, PS cleans the files first, adds the correct headers and formatting combined with a format file I have been able to get this to work and it is reliable.
If anyone does have any thoughts or suggestions please post them.