Create an SSIS package to load Employee.txt file in to LearningSSIS..tblEmployee Create table tblEmp in LearningSIS2 database
Fantastic news! We've Found the answer you've been seeking!
Question:
- Create an SSIS package to load Employee.txt file in to LearningSSIS..tblEmployee
- Create table tblEmp in LearningSIS2 database with the same schema as LearningSSIS..tblEmployee table
- (do not populate tblEmp)
- Create a SSIS package to load the data from LearningSSIS..tblEmployee to LearningSSIS2..tblEmp
- Create database Prospects
- Create table tbl_stg_Prospects in Prospects- (Refer to Project document)
- Create a SSIS package Load_Prospects_Staging.dtsx to load the data from Prospect_B.xls to tbl_stg_Prospect
- 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
Related Book For
Integrated Accounting
ISBN: 978-1285462721
8th edition
Authors: Dale A. Klooster, Warren Allen, Glenn Owen
Posted Date: