SELECT THE SOURCE TABLES AND VIEWS. DEPENDING ON WHAT KIND OF SOURC...

4. Select the Source Tables and Views. Depending on what kind of source

you selected, there may be multiple tables or views in the source that you

can import from. The wizard will allow you to select one or more of the

specific tables and views. Or if the data source is support queries, you

could instead write a query to extract just the data you want from the

source.

Once you have selected the source objects you can map them to

destination objects. If the destination tables already exist, you can select

them, or you can define new tables for the data to be loaded into.

The wizard will help to generate the SQL statement to create the target

table. You can also select options regarding whether existing data in the

destination table should be kept or cleared, how values for identity

columns should be handled, and so on.