Loading the Ragged Right file data in the table using Flat file connection Manager in SSIS

 Ragged Right File:

This file is similar to the fixed-width file only the difference is that this format file allows the last line to be variable length.

Some time we are not sure that the length of a column and we are extracting the data in the fixed file in this case we can put the column at the last and store the data in the fixed files.

See the below file.  

See the mapping  

Name: 0-20

Mobile: 21-35

Address: 36- variable Length

Let’s see how to load this file into the table.

Taking DFT and source as a flat-file.

  

Selecting the Format as Ragged Right.

In the Columns we are mapping the column.

 

In the advance we can see the list of columns with the length.

  

The preview we can see the data. 

Now taking Destination as OLEDB and doing the mapping.

 

The package is ready to run.

See the records in the table.

  

Running the package. 

Data loaded successfully.

See the records in the table

  

Data loaded successfully.