Execute SSIS package on vb.net
Hi All,
I would like to write a small applicationforexecute a SSIS package manually, but i got a error message as following:
Coding:Dim oPkg As DTS.Package2oPkg = New DTS.Package2'Error Message HereoPkg.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
March 11th, 2006 7:23am
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
Free Windows Admin Tool Kit Click here and download it now
March 11th, 2006 7:53pm
Thx you help a lot of me !!
March 11th, 2006 10:32pm
I can't found the namespace Microsoft.SqlServer.Dts.Runtime
Free Windows Admin Tool Kit Click here and download it now
March 13th, 2006 4:29am
how did you solve this issue ,I have this probelm on sql2008
September 22nd, 2011 1:42am
If you can't find the namespace, then it's likely you don't have the SSIS components installed. The SSIS components can be installed when you run the SQL Server installer. They also require a Standard or better license of SQL Server
on the computer you want to run the package on.
Talk to me now on
Free Windows Admin Tool Kit Click here and download it now
September 22nd, 2011 12:19pm