Suggestions on loading a fixed width file. We are receiving a fixed width file of about 1000 columns of varying length. We have a layout of all start and stop positions. I would like to read the layout and load the flat file without having to manually load the file using the import utility b/c it would take a while to click every position in the GUI of a 1000 column record. I have also created the table shell in SQL. If there is any way to quicking point to the file and read the position from the layout or sql table and then load it, this would be very helpful. Thanks!
My first thought is to 1. load the data as one column into a staging table 2. Load the layout into another staging table e.g. column_name,start,stop 3. Use some dynamic SQL generated from the layout table to parse the data table