March 13, 2008 at 5:38 am
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
March 13, 2008 at 6:50 am
SSIS packages must be accessed via the SMO and .Net.
The SQLDMO DTS class is only for DTS Packages. While this is valid code to run against a 2005 server it is only provided for legacy support of 2000 DTS.
Norman Kelm
DTS Package Search
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply