Newbie = Problem catching errors in an ActiveX task -- sql server dts

kumarbs NO[at]SPAM lycos.com
9/14/2004 6:08:12 AM

Folks,

I have a piece of code that looks something like:

On Error Resume Next

' Instantiate objects for the text and sql connections
set objPkg = DTSGlobalVariables.Parent
set objtxtConn = objPkg.Connections("txtConn")

If Err.Number <> 0 then ...

The code works fine. I just wanted to test the error handling code in
the IF block. I changed the connection name in the above line from
"txtConn" to "txtCaonn", I get an error popup that "txtCaonn"
connection was not found. If I entered a line such as "i=1/0" , the
task runs properly and the IF code catches the error.

Are there some errors in ActiveX that are immediately raised
regardless of whether the code was in a On Error Resume Next block ?

Krish
9/14/2004 1:17:13 PM

Try looking at package properties...you should be able to figure out error
handling settings... Dont take my word...im still newbie.......

[quoted text, click to view]

sql server dts : Newbie = Problem catching errors in an ActiveX task