DTS GetExecutionErrorInfo typemismatch

Hi All,

I think this is the correcty forum for this problem:


I'm trying to use vbscript to control DTS. I started with the vb code generated by saving the basic DTS package I need and inserted ito my vb. I had to sort various problems out but I've got to the point where I am completely bogged down by the following problem.

When I test the steps after execution for problems using the following line of code, I get a type mismatch error.

oPackage.Steps(i).GetExecutionErrorInfo ErrorCode, _ ErrorSource, ErrorDescription, ErrorHelpFile, _ ErrorHelpContext, ErrorIDofInterfaceWithError



I've got option explicit set, I've dim'd all the variables listed. I've tried forcing the variables to be initialised by setting errorcode=0 (and -1 ) and each of the string variables to "." all to no avail.

If I do a check on oPackage.steps.count it gives a value rather than an error so it doesn't look like that is the problem.

If I call the routine with the first parameter only without brackets I get the same error. If I use brackets I don't get an error but it doesn't return a value.

HELP!!!!!