Hi Phil,

Thanks for the reply.

I figured it out.

I had to use merge join task and implement the same.

Another update is that, the 3 records from the flat file will form a single row at the destination (table)

Thanks.

Hi Phil,

Thanks for the quick response.

I realized that I will have to use a conditional spilt task, since the records length is fixed for certain records only, which I did...

Hi,

I am developing the SSIS package to parse a non-delimited file.

Can you please help me on the script which is to be written to parse the file ?

Thanks