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?

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?

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.



Leave a Reply 1

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


Golden Bola

Golden Bola

59 yrs old Composer Amado Mosby from Saint-Jovite, usually spends time with passions which
include relaxing, Golden Bola and poker. Identified some amazing places following
9 months at Tyre.