Thanks all for your help

i have

1)st join which will fetch data of REQUESTOR info

using source-1's table-A + SOURCE'2 table-B

2)nd join which will fetch data of AUTHORIZER info

using...

in data flow

1st) use oledb-source

2nd) use charater map

3rd) flat file destination

in 2nd) use charater map

input column destination ...