As a junior database administrator for a market research firm. earlier today, you received a request from
Question:
As a junior database administrator for a market research firm. earlier today, you received a request from an analyst who needs a flat file extracted from a large table on a sql server database so he can load the file into his third-party analytical tool. he needs 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 needs, 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 need 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 field 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 separate file output. given the complexity of the process, you decide to develop an ssis package using sql server data tools. complete the following:
• using microsoft books online for sql server 2012, research and explain which control flow tasks and data flow components could be used to achiev
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi