First thing that comes to mind is to use the SQL Server Import and Export Wizard from SSMS. (right click on the target sql database->Tasks->Import data) Walk through the Wizard and save as package, then import the package into a SSIS project.

😎