Microsoft® SQL Server® 2012 Bible

(Ben Green) #1

629


Chapter 23: Transferring Databases


23


exists, it enables you to either delete or append rows to the destination table.
If no destination table exists, it enables creation of a new destination table.

FIGURE 23-9
Confi guring the destination table and column mappings.


  1. Depending on how you launch the Import and Export Wizard, the wizard works
    differently. For example, if you launch the wizard from SSDT, in the last step you
    cannot run the resulting package; instead the package is saved as part of the SSIS
    solution. On the other hand, if you launch the wizard from any other method (for
    example, Management Studio), the wizard enables running the package in the last
    step, as shown in Figure 23-10.


c23.indd 629c23.indd 629 7/31/2012 9:25:23 AM7/31/2012 9:25:23 AM


http://www.it-ebooks.info
Free download pdf