Custom Log Provider - Notification Services
Hi...
I am trying to do custom log provider that will post events to Notification Services...The idea is that if I could post the "SSIS events" to Notification Services, with a Custom Delivery Channel in NS, I would be able to do NS Subscriptions with real time monitoring of SSIS packages..
I have tried to use the sample custom log provider code in MSDN. The problem is after I added the custom log provider dll to the C:\Program Files\Microsoft SQL Server\90\DTS\LogProviders folder and install to global assembly using gacutil...
The custom log provider is not showing up in the Provider Type under Configure SSIS logs...
[660 byte] By [
popoi90] at [2007-12-18]
Attribute and parameters are below...
[
DtsLogProvider(DisplayName="NSLogProvider",Description="Notification Services Log Provider.")]public class NSLogProvider : LogProviderBase
Can you send the sample to my emailaddress peter.ang@comcast.net?
Much appreciated,
Peter Ang
Peter,
Easy though somewhat annoying solution for this one...the LogProviderType property in the attribute, although not currently used, is "required" -- this is why your log provider is now showing up as available. I believe that any string value is acceptable. This property may be used in the future for grouping.
The attribute also supplies the UITypeName property which you may recognize from similar attributes if, for example, you've tried writing a custom connection manager or other custom SSIS object. In the case of a log provider, the "ui" is limited to displaying a filtered list of connection managers in the Configuration column rather than the default textbox. However, support for custom ui's is not implemented in this release for custom log providers. (I didn't want you to waste more time trying something that isn't implemented.)
The default Configuration textbox offers some interesting flexibility. For example, I've written an Email Log Provider that expects a config string in the format:
<smtp server>;<to address>;<from address>;<text or html>
-Doug
