Runs dtsx package from vb code

See more:

SSIS

VB12

Hi -

I have a web page that I'm trying to access an ssis package and run the import. The issue is that the package fails with an error of

'Failed to open package file "@P:\Users\TroyB\KitImport.dtsx" due to error 0x8007007B "The filename, directory name, or volume label syntax is incorrect.". This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format.'

The excel file location is hard coded for now along with location of the import package. Here is the example of that I was following :Excecute SSIS package (DTSX) from ASP.Net[^]

Here is the code :

Dim pkgLocation As String
Dim pkg As New Package
Dim app As Application = New Application
Dim pkgResults As DTSExecResult
Dim fileName As String = "@P:\Users\TroyB\MyKitImport.xls"
Dim eventListener As New EventListener
pkgLocation = "@P:\Users\TroyB\KitImport.dtsx"
pkg = app.LoadPackage(pkgLocation, eventListener)
pkgResults = pkg.Execute()

Thanks in advance