June 28, 2011 at 1:15 pm
I inherited an *interesting* SSIS package. It contains several DFTs that each execute a different stored procedure in the database. A log table was created in the database, and each DFT uses the OnPreExecute and OnPostExecute to write to this log (I think). For example, entries in the log file contain messages like:
2011-06-28 13:48:23.570 Started Loading HouseholdsNSI_Characteristics
2011-06-28 13:48:26.587 Finished Loading HouseholdsNSI_Characteristics
2011-06-28 13:48:26.617 Started Loading HouseholdsNSI_Fault Table
2011-06-28 13:49:06.820 Finished Loading HouseholdsNSI_Fault Table
I added a new DFT to execute a new stored procedure. As my starting point I copied another DFT and changed the name of the stored procedure being executed. All is working fine except my new DFT is not writing to the log table. How do I apply the same event handler to my DFT as the others?
June 28, 2011 at 1:31 pm
You need to copy the event handler as well. Each task in an SSIS has its own event handlers, so you'll need to create a new one for the new dataflow.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 28, 2011 at 1:44 pm
How do I go about copying the Event handler(s)? The event is an execution of a stored proc that takes in parameters to update the log table.....I need to know how to make this happen in my new DFT (with parameters that are unique to my DFT).
June 28, 2011 at 1:49 pm
I just figured it out. Thanks !
June 28, 2011 at 1:53 pm
hallhome (6/28/2011)
I just figured it out. Thanks !
Great, glad you found the solution without me typing anything 😀 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply