Thanks again,

I was able to workaround it, i deselected the address column which had a data type of varchar(max). This was subsequently not used in the transformation.

I decided the...

Thanks so far for advice and links

I proceeded by trying to filter the input columns, by allowing the rows rows which were not going to be used to be selected...

It was an excellent read. I tried reducing the maxrow count in each buffer to 1000(as to the default of 10000). Still no luck, i get the same message

Information: 0x4004800C...