How to check job status from SSIS control thread?

Question

Here is my scenario - I have an SSIS job that depends on another previous SSIS job to run. I need to check the first job status before I send the second one. It is not possible to add the second task to the workflow of the first, because it is already too complicated. I want to be able to check the first status of the job (Failed, Successful, Executing) from the second and use this as a condition to decide whether the second should start or wait for a repetition. I know this can be done by querying the MSDB database on the SQL Server doing the job. I am wondering if there is an easier way, for example, perhaps using the WMI Data Reader Task? Has anyone had this experience?

Answer 1

You might want to create a third package that launches package A and then packageB. The third package will contain only two tasks of the execution package.

http://msdn.microsoft.com/en-us/library/ms137609.aspx

@Craig A status table is an option, but you will need to keep track of it.

Here is an article on SSIS events for your original question.
http://www.databasejournal.com/features/mssql/article.php/3558006

Answer 2

? . . , . () , - (, , , ):)

@Jason: , , , .:)