Thanks a lot...you almost gave me the solution...I would try using merge join...

you can get that using pivot transformation in SSIS...

yeah...u shud be more specific...u mean u wanna split a single column to split into 2 columns??

thanks a lot....let me try it...

ok ya...they r not dimension tables and fact tables...below are the details of the 6 source tables and the destination table...they are all in 2 different databases in the same...

Thanks for reply....Actually I have to populate a fact table from the dimension tables....fact table consists of datetime,userid,userlocation,officeid,officelocation,insurancename,providerid,groupname,groupid,accountnumber...I have all this data in 6 different tables...so, I have...

I think you can add those packages from the menu bar in the start page like project->add existing package. try that...