I'm importing a flat file into SSIS which needs to be split into two tables. In my input file I have a few columns (just an example.. I'm not really working with boxes): Box contents, box weight, box ...

I have to import flat files into MSSQL server. So far, I've used SSIS packages and Delphi programs to do the job but I'm getting more and more files to load. Many are very wide (more than 90 fields) ...