MCSA Guide to Microsoft SQL Server 2012 (Exam 70-462) 1st edition

If other online sources are used to answer the question, please include the URLs in your response. Thanks!

Case Project 9-1: Market Research Firm You work as a junior database administrator for a market rescarch firm. Earlier today, you received a request from an analyst who nceds a flat file extracted from a large table on a SQL Seer database so he can load the file into his third-party analytical tool. He nceds the comma-separated values file before the end of the day and has indicated that this is a one-time request. Complete the following: Compare and contrast the two best options for meeting his nceds, given the scope of the . request and any constraints that you have identified. Which solution would you choose and why? A week later, the analyst informs you that the analysis he performed based on the ex- tracted data was extremely valuable, and he has been asked to perform this analysis on a daily basis. That means you will nced to set up a daily extract of the data. The analyst has also asked if you can implement a process to remove records from the flat file that have missing ficld values. He wondered if it would be possible for a list of these bad records to be sent to him in an email, or as a scparate file output. Given the complexity of the proc ess, you decide to develop an SSIS package using SQL Server Data Tools. Complete the following: Using Microsoft Books Online for SQL Server 2012, rescarch and explain which control flow tasks and data flow components could be used to achieve this objective. Draw a design of the control flow and data flows that y you propose to usc