Data Warehousing Project $4$

Project Description

To complete this project, you will install SQL Server, SQL Server Management Studio and Visual Studio with the SSIS package using this tutorial. You will also create an ETL package in Visual Studio. Please watch all of the videos in the tutorial and complete all of the steps.

After you complete the tutorial, create a video to demonstrate completion of the project. In case you haven't made videos before, Screencast$-$o$-$matic is a great tool, and it's free! Just go to the home page and click on Record for Free, then Launch Free Recorder. They also have great tutorials on the webpage.

I will be the only person watching your video and you do not need to show your face. You will need to talk during the video. If you are unable to talk during the video, please email me so we can discuss alternatives. Your video should be professional and as such could be something that you share with a potential employer to demonstrate your competency in using database tools.

$1.$ Create a video that is about two to three minutes long, including your name and a brief description of the project. $(5$ points$)$

$2.$ Show the package that you created in Visual Studio. $(5$ points$)$

$3.$ Show the data flow task that you created in Visual Studio and briefly describe each object. $(5$ points$)$

$4.$ Show the table and columns that were created in SSMS$.(5$ points$)$