With your description temp table is not a good idea; certainly it will take more time and use more resource; unless you are missing any detail.

Yup, easy solution is just Select destination database; right click go to Tasks -> Import Data.

A wizard will show up to import and that give option to import from...