VBS and DTS as a VB module

VBS and DTS as a VB module

Post by Marcus Johnso » Sat, 31 Mar 2001 23:52:34

I have recently created a DTS package and saved it as a vb module in SQL
2000.  I then incorporated it into an existing VB program that I had.  The
question that I have is doing the error trapping for system functions.  I
actually built an error handler for errors within the DTS package module but
when the sytem encounters and error such as an invalid login or a database
not available then it pops up a message box and does not pass these to the
error handler.

Does anyone have any idea how to trap these sytem database events and handle
them accordingly?