This SSIS Integration Services article shows how to load data from a Fixed Width Flat file to the SQL Server table with an example.
SSIS Load Fixed Width Flat File Data to SQL Server
Drag and drop the Data Flow Task into the control flow region.
First, change the Format from default Delimiter to Fixed Width. And If the file’s first row has header names, checkmark the Column Names in the first data row option.
We must use/drag the red line within the Column tab.
Now, you can see all the columns with values.
Click on the empty space before each column starts to generate a black line that divides the columns.
Use the advanced section to change the Data type. Here, the column data type must match the destination table; otherwise, it throws an error. After you finish, click OK to close the window.
Select the existing table from the list. If not, click the new button to create a new one.
Next, go to the Mappings tab to check the input and available destination column mapping. If not, assign them by dragging the lines or using a drop-down list.
Run the SSIS Load Fixed Width Flat File Data to SQL Server package.
Open the SQL Management Studio to see the result.