Struggling with dts from .NET

SQL Server Integration Services

enric vives


Hi everyone,

We've got running an vb .net service which throws on-demand .DTSX. Now a new feature has been added: it must be able to launch dts 2000/7.0 too. No problem with that. It works fine using the same thread.

Issue comes when we were accostumed to cancel any DTSX execution for sake IDTSEvents interface and OnQueryCancel event. We want to the same but for the old ETL.

My wonder is how do the same but related with DTS

I attached you this snippet of code which is responsible for launching a dts:

Private WithEvents paquete As DTS.Package2

paquete = New DTS.Package2

paquete.LoadFromSQLServer("SRVDESA1", , , DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection, , , , "pruebaenric")

paquete.Execute()

Private Sub paquete_OnQueryCancel(

stuff (NEVER ENTRY HERE)

Private Sub paquete_OnProgress(ByVal EventSource As String, _

stuff (NEVER ENTRY HERE)

Private Sub paquete_OnError(ByVal EventSource As String, _

stuff (NEVER ENTRY HERE)

Let me know what's happening Is something related with managed and unmanaged code Any COM feature or something like that

Or is only that I've got to define a private class how I did with SSIS and to use one specific interface

Primary platform is Framework 2.0

Thanks in advance for your time and information provided,

Enric




Top

Re: Struggling with dts from .NET

enric vives


Hi there,

http://support.microsoft.com/default.aspx scid=kb;EN-US;q321525

This issue is almost solved. Thanks anyway.






Top