Question

Purpose of SQLISPackage_12546 event in SQLIS package is to _____________

(a) Indicate that a package started

(b) Indicate that a task or other executable in a package has finished its work

(c) Indicate that a warning message was raised in a package

(d) All of the mentioned

The question was asked in an interview for internship.

This intriguing question comes from Integration Services topic in portion Data Connectivity of SQL Server

Answer 1

Correct option is (b) Indicate that a task or other executable in a package has finished its work

For explanation I would say: SQLISPackage_12288 indicates that a package started.