Hi,
I’ am trying to execute a SSIS package from MS Access. I have made the package, I have add reference to Microsoft DTSPackage Object Library and finally write the on button click procedure listed below
Dim oPKG As New DTS.Package
oPKG.LoadFromSQLServer "HLCTUB001", , , _
DTSSQLStgFlag_UseTrustedConnection, , , , "Package1"
oPKG.Execute
oPKG.UnInitialize
Set oPKG = Nothing
The code is not executing correctly and comes the error:
The specified DTS Package(‘Name=’Package1’;ID.VersionID={[not specified]}.{[not specified]}’) does not exist
I suspect that the execution method is not right cause it has reference to a DTS package. I think I have to change something to my code but I don’t know what.
Any help is appreciated
I’ am trying to execute a SSIS package from MS Access. I have made the package, I have add reference to Microsoft DTSPackage Object Library and finally write the on button click procedure listed below
Dim oPKG As New DTS.Package
oPKG.LoadFromSQLServer "HLCTUB001", , , _
DTSSQLStgFlag_UseTrustedConnection, , , , "Package1"
oPKG.Execute
oPKG.UnInitialize
Set oPKG = Nothing
The code is not executing correctly and comes the error:
The specified DTS Package(‘Name=’Package1’;ID.VersionID={[not specified]}.{[not specified]}’) does not exist
I suspect that the execution method is not right cause it has reference to a DTS package. I think I have to change something to my code but I don’t know what.
Any help is appreciated
