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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics