• 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