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...

The attribute and its values are the most important settings. Can you paste what you have for that? I also have an example I could Zip and send to an email address...

-Doug

|||

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

|||

Can you send me your Email Log Provider sample to this emailaddress ?

peter.ang[at]comcast.net

Thanks

|||

Doug,

Could you please email me your Email Log provider Sample to wy6688@.yahoo.com?

Thanks a lot.

|||

Grab the latest SQL Server samples, and it is now included in there. Default install location is - C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Programming Samples\Control Flow\EmailLogProvider Sample

Download details: SQL Server 2005 Samples and Sample Databases (July 2006)
(http://www.microsoft.com/downloads/details.aspx?FamilyId=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en)