Question: 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

Create basic SSIS Package to enter the files provided in "ETL_Diagram Section Files" to a new Database called 

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

Step by Step Solution

3.38 Rating (142 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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 full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!