What can be monitored using SSIS?

[tigerjj85]

Hi, I've been trying to use the search and weren't very successful.

So, Here is my question.

What can be monitored using SSIS? (ie. performance)
If so, is there scripts available in this forum?

Thank you
-JJ-

 

[SQLBill]

What do you mean by monitored? SSIS is not Profiler. It is the replacement for DTS.

Tek-Tips does not have a script library. When a poster has a question, people either provide a script or advice on how to create the script. A lot of times the script is just an example which the poster needs to convert to their own environment.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[tigerjj85]

Thanks SQLBill.

I just read an article about Event Forwarding

Does anyone here use it? and what kind of things do you guys use them for?

 

[MDXer]

From what I have read on this you can monitor perf counters and utilize the info returned. By using the event hanlers you can send notifications or audit what messages are returned. For example I use the On Error event and log all error messages and email a report of all messages that occured during a process.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck