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 ?

Thanks !

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

"Kumar" <kumarbs (AT) lycos (DOT) com> wrote