InteropServices.COMException

[msnews.microsoft.com]

I'm in the middle of converting an old vb6 app to dot net and I'm having a
problem with running a DTS package. I keep getting this runtime error and
I'm sure why or how to fix.

Run-time exception thrown : System.Runtime.InteropServices.COMException -
Type mismatch.

Here's my code snippet:

objPKG = CreateObject("DTS.Package")

objPKG.LoadFromSQLServer("TEST", "sa", "test1234", 0, "", "", "",
strPackageName)

For Each oStep In objPKG.Steps

If oStep.ExecutionResult = 1 Then

oStep.ExecuteInMainThread = True

MsgBox(CStr(objPKG.Tasks(oStep.TaskName).Description))

End If

Next oStep

 

[Adel Al-saleh]

I'm in the middle of converting an old vb6 app to dot net and I'm having a
problem with running a DTS package. I keep getting this runtime error and
I'm sure why or how to fix.

Run-time exception thrown : System.Runtime.InteropServices.COMException -
Type mismatch.

Here's my code snippet:

objPKG = CreateObject("DTS.Package")

objPKG.LoadFromSQLServer("TEST", "sa", "test1234", 0, "", "", "",
strPackageName)

For Each oStep In objPKG.Steps

If oStep.ExecutionResult = 1 Then

oStep.ExecuteInMainThread = True

MsgBox(CStr(objPKG.Tasks(oStep.TaskName).Description))

End If

Next oStep

Hi Brian,

What version of .Net Framework do you use?

Also, I don't see any code for destroying the object after instansiating and use?!


Adel A. Al-saleh