You are designing a SQL Server Integration Services (SSIS) package that uploads a file to a
table named Orders in a SQL Azure database.
The company’s auditing policies have the following requirements:
An entry must be written to a dedicated SQL Server log table named OrderLog.
The entry must be written as soon as the file upload task completes.
You need to meet the company’s policy requirements.
Which event handler should you use?
A.
OnPostExecute
B.
OnWarning
C.
OnExecStatusChanged
D.
OnVariableValueChanged
Explanation:
http://msdn.microsoft.com/en-us/library/ms140223.aspx
This is an example of a stupid question. Of course the answer is PostExecute, unless its OnExecStatusChanged. I’ve never heard of it, but it sounds tempting. Oh look:
https://connect.microsoft.com/SQLServer/feedback/details/553217/ssis-event-onexecstatuschanged
People have asked about it and it’s generally tempting, but it turns out, it’s useless. It’s only used to report execution status during debugging with breakpoints. But the only way to know that and be confident that the answer is surely onpostexecute is by looking it up. This is why we have to do these tests beforehand.
I like the valuable info you supply for your articles. I will bookmark your blog and take a look at once more here frequently. I’m rather certain I will learn a lot of new stuff proper here! Best of luck for the following!|