Create basic SSIS Package to enter the files provided in ETL_Diagram Section Files to a new...

 

Transcribed Image Text:

Create basic SSIS Package to enter the files provided in "ETL_Diagram Section Files" to a new Database called Curriculum. The SQL Script will be executed within SSIS in a SQL Task (The script may be too big to use in a SQL Task. In that case, find another alternative such as putting the script inside a Stored Procedure.) The Excel file will be loaded within SSIS as well. The end result will be 6 tables loaded to the new Database. a. b. C. d. e. Provide screen shots that document the whole process Below each screen shot should be a brief explanation of what you are doing. The package should have the ability to run multiple times giving the same results. Your final document should be written as if the reader was new to SSIS. Include at least 6 different SSIS components in your package with 3 of them being Data Create basic SSIS Package to enter the files provided in "ETL_Diagram Section Files" to a new Database called Curriculum. The SQL Script will be executed within SSIS in a SQL Task (The script may be too big to use in a SQL Task. In that case, find another alternative such as putting the script inside a Stored Procedure.) The Excel file will be loaded within SSIS as well. The end result will be 6 tables loaded to the new Database. a. b. C. d. e. Provide screen shots that document the whole process Below each screen shot should be a brief explanation of what you are doing. The package should have the ability to run multiple times giving the same results. Your final document should be written as if the reader was new to SSIS. Include at least 6 different SSIS components in your package with 3 of them being Data

Answer rating: 100% (QA)

Open SQL Server Data Tools SSDT Start by opening SSDT which is a development environment for creating SQL Server Integration Services SSIS packages Cr... View the full answer