LAB 3 : Creating an ETL Solution with SSIS
Exercice 1:
Task 1
1. Start SQL Server Management Studio and connect to the (local) instance of the SQL Server
database engine by using Windows authentication.
2. Restore files all files in the « LABS-Atelier SID\Lab03\BackupFiles » folder. Indication : Refer
Publicité
to « Préparation Environnement Labxx » file in the « LABS-Atelier SID » folder for help.
Task 2:
Task 3 :
1-
Exercice 2:
Task 1:
Publicité
Task 2:
Task 3:
Task 4:
Exercice 3:
Task 1:
Task 2:
Publicité
Task 3:
Task 4:
Task 5:
Task 6:
Task7: