Administrating the Core Database Engine - Microsoft SQL Server 2008 R2 Administration - page 73

6. Similarly, using SQL Server 2008 R2 client tools, you can choose SQL Server
Management Studio (SSMS) or Business Intelligence Development Studio (BIDS).
7. Right-click the SSIS Packages folder and select the SSIS Import and Export Wizard.
8. Using BIDS tool, go to Project menu, choose the SSIS Import and Export Wizard.
9. For the ease of this recipe, we will skip to the screen where you need to save the
package (see the next screenshot) as the Import and Export wizard, which has the
self-explanatory screens to proceed.
10. We need to provide all the necessary information to create an import or export task
and once we get to the save and Run Package screen, you need to choose Run
immediately, if it is a one-off requirement to perform ETL activities.
11. In case the referred ETL process is a continuous task to schedule for administrative
processes, we need to choose the Save SSIS package option with two more options
to choose from.