Wednesday, March 7, 2012

Events for LoadFromSqlServer method?

Hi everyone,

I was wondering what kind of events fires when you do a LoadFromSqlServer method? I've got defined a Events class but debugging with F11 never get in touch with any event (apparently or mabye the problem

is that I haven't declared that concrete one)

Let me know if possible or not. I provide you my snippet of code:

Dim pkg As New Microsoft.SqlServer.Dts.Runtime.Package 'Para que no choque con el objeto APPLICATION DE SYSTEM.WINDOWS.FORMS

Dim app As New Microsoft.SqlServer.Dts.Runtime.Application

Dim EventsSSIS As Eventos

EventsSSIS = New Eventos()

..

..

pkg = app.LoadFromSqlServer(ObjSSIS.sRutaDts & "\" & ObjSSIS.sSSISName, ObjSSIS.sServer, "usrSSIS", "aaa", EventsSSIS)

..

..

Public Class Eventos

Implements IDTSEvents

OnTaskFailed(ByVal taskHost As TaskHost) Implements IDTSEvents.OnTaskFailed

OnWarning(ByVal source As DtsObj

OnPreValidate

..

..

Thanks in advance,

Any idea? Jamie?

TIA

|||You'll get OnError and OnWarning if there are any problems with the package (e.g. the package is encrypted and the password you supplied is incorrect).|||Ok, thanks a lot for that.

No comments:

Post a Comment