i've got a big bundle of fixedwidth flatfiles to import.
i have the supplier documentation to show me where the columns in each file start/end.
but, there's too many columns and too many files to go through to set up the data flow flat file source connections manually.
as i have the documentation for the file structure for each file, is there a way for SSIS to read some form of format file built from that that shows SSIS where columns start/end for any given file? (i've looked at bcp format files, but it seems they don't specify startend positions for columns and to create the format file i need to specify the field terminator, something not present in these fixedwidth files)
i won't be able to get the files sent over in delimited form so all hints/tips/help greatly appreciated.