April 22, 2009 at 9:00 am
Hi
I have a SSIS package which has 4 tasks, eg task1, task2, task3 and task4. These run sequentially, ie task1 --> task 2 --> task 3 --> task 4.
When I run it in Visual Studio via debug mode and then have a look at the Execution Results tab, the information displayed doesn't reflect the order of the execution of the tasks as specified in the Control Flow tab. It's displayed in the order task3, task 2, task 4 and finally task 1.
I have implemented logging and the log events are written out to the sysssislog table. It has been populated with the log events. However, I cannot seem to order it in the sequence I expect it to be.
It seems to reflect the order of the Execution results tab.
Am I not understanding something or do I need to add some information to the logs? At the moment I am recording the OnError, OnPostExecute, OnPreExecute, OnProgress, OnTaskFailed and OnWarning.
We want to run a sql query against the logs to check the job run.
Thanks for any help.
May 21, 2009 at 4:48 am
Sets are unordered by definition. If you want the results of a query to be returned in a specific order, you need to specify it using ORDER BY when retrieving data from the table (i.e. in the SELECT statement).
You can use the StartTime and/or EndTime columns of the sysssislog table to sort the results.
ML
---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply