Can you explain the what the Import\Export tool does and the basic steps in the wizard?

Answer 1

The Import\Export tool is accessible via BIDS or executing the dtswizard command.
The tool identifies a data source and a destination to move data either within 1 database, between instances or even from a database to a file (or vice versa).