July 12, 2011 at 4:12 am
Hi All!
I enabled logging on my package to log into a database (SQL Server 2005 - sysdtslog90) to log the events: OnError, OnPostExecute, OnPreExecute, OnTaskFailed, PackageEnd and PackageStart.
Everithing is working as expected with one strange detail.
My package has over 10 tasks on the control flow and one data flow, but between each OnPreExecute and OnPostExecute for each task, it is loggin a OnPreExecute and OnPostExecute for dataflow task, so I have something like this:
OnPostExecuteGet List of Clients
OnPreExecuteForeach Client
OnPreExecuteData Flow Task
OnPostExecuteData Flow Task
OnPreExecuteSet the Loop Control Variable
OnPreExecuteData Flow Task
OnPostExecuteData Flow Task
OnPostExecuteSet the Loop Control Variable
OnPreExecuteGet List Of Periods
OnPreExecuteData Flow Task
OnPostExecuteData Flow Task
OnPostExecuteGet List Of Periods
Im implementing log for the first time, so I ask: is this normal behaviour?
Thanks
July 12, 2011 at 5:50 am
I see you have a for each loop, is the dataflow inside this loop?
The OnPreExecute and the OnPostExecute event handlers can be fired more than once (especially the ones on the package level), so I wouldn't spend too much attention to it.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 12, 2011 at 5:58 am
Hi koen!
Yes I use a loop but the tasks outside the loop also have the same behaviour.
It it not causing any trouble but I would like to know why those entries are beeing made to the log.
thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply