PrepAway - Latest Free Exam Questions & Answers

what should you do make sure that the parent package can discover the execution state of the child packages?

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. Now you design a SQL Server Integration Services (SSIS) solution. You intend to deploy the projects in the manner below:
A parent package on an instance which is named SSIS1.
Three child packages individually on three instances which are named SSIS2, SSIS3, SSIS4.
So what should you do make sure that the parent package can discover the execution state of the child packages?

PrepAway - Latest Free Exam Questions & Answers

A.
You should configure the parent package to log its events to a SQL Server log provider.

B.
You should configure the child package to log their events to a SQL Server log provider.

C.
You should configure the child package to log their events to a SQL Server Profiler log provider.

D.
You should configure the parent package to log its events to a SQL Server Profiler log provider.

One Comment on “what should you do make sure that the parent package can discover the execution state of the child packages?


Leave a Reply