Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

DTS Events + VB.NET

0 views
Skip to first unread message

Arian Haeser

unread,
Jan 21, 2003, 9:29:50 AM1/21/03
to
SQL Server: 2000, VB.NET + SP1

I'm trying to handle DTS events. But when I try to ececute it, it fails and
says: "Execution canceled by user"

After some research I found this:
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b319058

But that method doesn't resolve my problem..

Can anyone help me?
Thanx alot,
Arian Haeser


Part of the code:

dim withevents oPackage as new DTS.package()

oPackage.LoadFromStorageFile(FileName, m_sPassword)
Dim oStep As DTS.Step
For Each oStep In oPackage.Steps
oStep.ExecuteInMainThread = True
Next
oPackage.Execute() <<-- This line fails...


'I've implemented all events like this: and set the pbCancel to false if
needed

Private Sub oPackage_OnStart(ByVal EventSource As String) Handles
oPackage.OnStart
'stub
End Sub


Arian Haeser

unread,
Jan 21, 2003, 9:51:38 AM1/21/03
to
Found solution:
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b321525

Arian Haeser


"Arian Haeser" <a...@RTRTRT.nl (remove R;s)> wrote in message
news:us3bZnVwCHA.2472@TK2MSFTNGP12...

0 new messages