Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sundevilscott
Starting Member
12 Posts |
 Posted - 2010-06-09 : 16:54:49
|
| Hello All -I am trying to find an easy way in SSIS to run an SP just before and after a data flow task runs. So i would like to run my sp that does import time to import start time and finish time. trying to see how long each table takes to load from the AS400 and I don't want to set up a ExecuteSQL Task before and after each flow task.In the Event Handling there are 2 events called Pre and Post Execute but that did not work. I now believe those are for executables.Any help would be great and I hope I did not confuse everyone.Scott |
|
|
kannansoft
Starting Member
1 Post |
Posted - 2010-06-16 : 03:21:57
|
| You can place Execute SQL Task in these 2 event handler (Pre and Post Execute) and configure you SP in this task.Kannan |
 |
|
|
gaauspawcscwcj
Starting Member
29 Posts |
Posted - 2010-06-23 : 03:34:00
|
| but one things must be carefully that : Pre will run 2 time at the first task in control flow pre runningand Post Execute will run 2 time at the last task in control flow is donegaauspawcscwcj |
|
|
|
|
|
|
SSIS Event Handling question