Try out a Execute SQL Task with the following code
create table #temp (cust_id int,phone_type varchar(10),phone_number int)
insert into #temp values(10001,'Home',1234),(10001,'Business',5678),(10001,'Mobile',918239)
selectcust_id,
max((case when phone_type='Home' then phone_number else 0 end)) as home_phone,
max((case when phone_type='Business' then phone_number else 0 end)) as Business_phone,
max((case when phone_type='Mobile' then phone_number else 0 end)) as Mobile_phone
from #temp
group by cust_id
--drop table #temp