Page 197 - DCAP508_DATABASE_ADMINISTRATION
P. 197
Unit 14: SQL Server Integration Services
8. Read the first page of the Import and Export Wizard and click Next. Notes
9. Select SQL Native Client for the data source and provide login information for your test
server.
10. Select the AdventureWorks database as the source of the data to import.
11. Click Next.
12. Because you’re importing data, the next page of the wizard will default to connection
information for the Chapter16 database. Click Next.
13. Select Copy Data From One or More Tables or Views and click Next.
Notes that if you only want to import part of a table you can use a query as the data source
instead.
14. Select the HumanResources.Department, HumanResources.Employee,
HumanResources.EmployeeAddress,
HumanResources.EmployeeDepartmentHistory, and
HumanResources.EmployeePayHistory tables, as show in Figure 14.1. As you select tables,
the wizard will automatically assign names for the target tables.
Figure 14.1
LOVELY PROFESSIONAL UNIVERSITY 191
