1. Create an SSIS package to load Employee.txt file in to LearningSSIS..tblEmployee

1. Create table tblEmp in LearningSIS2 database with the same schema as LearningSSIS..tblEmployee table

1. (do not populate tblEmp)

1. Create a SSIS package to load the data from LearningSSIS..tblEmployee to LearningSSIS2..tblEmp

1. Create database Prospects

1. Create table tbl_stg_Prospects in Prospects- (Refer to Project document)

1. Create a SSIS package Load_Prospects_Staging.dtsx to load the data from Prospect_B.xls to tbl_stg_Prospect

1. Modify Load_Prospects_Staging.dtsx to include the following
   • Truncate the tbl_stg_Prospects table before loading the Prospect_B.xls file.
   • Add functionality to load multiple Excel files