which control flow element should you use?

You’re the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to design a Business Intelligence (BI) solution. You intend to analyze customer interests for the various sections of the Web site. When performing the analysis, you can get the information you need in the log files on the web server. In order to use the information, you want to load the information into a database by designing a SQL Server 2008 Integration Services (SSIS) solution. You have to enumerate the log files that are stored on the Web server. So which control flow element should you use?

You’re the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to design a Business Intelligence (BI) solution. You intend to analyze customer interests for the various sections of the Web site. When performing the analysis, you can get the information you need in the log files on the web server. In order to use the information, you want to load the information into a database by designing a SQL Server 2008 Integration Services (SSIS) solution. You have to enumerate the log files that are stored on the Web server. So which control flow element should you use?

A.
You should use File System task

B.
You should use Sequence container

C.
You should use Data Profiling task

D.
You should use Foreach Loop container



Leave a Reply 0

Your email address will not be published. Required fields are marked *