Loading the fixed length file data in the table using fixed width file connection Manager in SSIS

 We are getting the fixed-width file we need to load the file into the database table.

Below is the file.  

Mapping of this file

Name: 0-19

Mobile: 19-34

Address: 34-60

In this demo, we will see how to load this Fixed width file.

In DFT we are taking Source as a flat file

We are creating the flat file connection manager  

Selecting the Format as Fixed Width.

Now come to the column 

We are creating the columns and proving the length of each column.

 

Now click ok.

Taking Destination as OLEDB destination. And doing the mapping.

 

Now running the package

 

See the records in the table.

 

Record loaded successfully.