Yes, very much so.
Right click on the database, and choose Import/Export (there are various options but this one will illustrate best).
Go through the GUI and remember to save the SSIS package.
This should give you a fair idea of what the workings are.
~PD