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 |
|
Gopher
Yak Posting Veteran
83 Posts |
 Posted - 2010-08-03 : 03:28:25
|
| Hi AllI have created an SSIS Package to run about 15 various tasks, however what to know when each of the task starts and how long it takes. I have looked into the test logging in SSIS but it is not enough.Does anyone know if this is possibe? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-03 : 03:40:59
|
| you can use event handlers for on post execute and on preexecute events. add a sql task and call a procedure to do insert in log table with time. the difference between them gives duration.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Gopher
Yak Posting Veteran
83 Posts |
Posted - 2010-08-03 : 03:48:19
|
| Ah, ofcourse!Thanks |
|
|
|
|
|
|
Specific Logging to Text file