Linked Server and SSIS

In order to mash up data from different sources and put them into destination server/table/DB research about Linked Server in MSSM or SSIS in VS2010 Video here