VB – DTSLib.DTSExecResult – compile error – Automation type not supported in visual basic-Collection of common programming errors

12 years ago

admin

1 minute

Dim pkg As DTSLib.Package
Dim pkgResult As DTSLib.DTSExecResult

This line (line:2) throws a compile error “Automation type not supported in visual basic” I’m trying to use pkgResult to capture the results of running a dtsx on server

Set pkg = app.LoadFromDtsServer("\MSDB\", Server, True, pevents)
pkgResults = pkg.Execute()

Please note: I have added a reference to “Microsoft DTS Runtime 1.0”

Doesnt VB support type DTSLib.DTSExecResult ??

Appreciate your help and time. Thanks