Hi All,
I would like to write a small application for execute a SSIS package manually, but i got a error message as following:
Coding:
Dim oPkg As DTS.Package2
oPkg = New DTS.Package2
'Error Message Here
oPkg.LoadFromSQLServer("SQL2005", "sa", "abc", DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, Nothing, Nothing, Nothing, "AccessImport")
oPkg.Execute()
oPkg.UnInitialize()
oPkg = Nothing
Error Message:
The specified DTS Package ('Name='AccessImport';ID.VersionID = {[not specified]}.{[not specified]}') does not exist.
So what is the problem here?
Thank a lot.
Laputa
You're using the DTS2000 object model.
You need the Microsoft.SqlServer.Dts.Runtime .Net namespace!
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9mref/html/N_Microsoft_SqlServer_Dts_Runtime.htm
-Jamie
|||Thx you help a lot of me !!|||I can't found the namespace Microsoft.SqlServer.Dts.Runtime
No comments:
Post a Comment