I can suggest you a very raw but powerful approach.
Write one-to-mapping and load the source file in staging table .
write the sp which you will call at then end of the mapping.

The sp will do something like this.

read the second column(as first column will be col names like BSLA,
Account.. etc)
read only that many number of rows of the second column which will consitute
a record.
This will give you yuour first record AAIDOM,440001002,'001,ADMBBB,Asset
Inte,ADMINISTRA,-22433.77,22433.77
repeat this till you consume the all the rows in second column.