Interop.DTS Setting a connection

#1

I'm using the assembly Interop.DTS in VB.Net for executing DTS-packages
stored local on a database-server. First I set some global variables, no
issues here, but when I want to set a datasource it says that the connection
cannot be found, though the name of the connection is certainly present in
the DTS-package.
Any change that some security-settings can make this difference, and if so,
which security settings?

Part of the code I use:

pkg = New DTS.Package2Class

pkg.GlobalVariables.AddGlobalVariable("name", "value")
pkg.Connections.Item("ConnectionName").DataSource = something

#2

try

connections = pkg.Connections
connections("ConnectionName").DataSource = something

"Chris Plenter" <ChrisPlenter (AT) discussions (DOT) microsoft.com> wrote

Quote:

I'm using the assembly Interop.DTS in VB.Net for executing DTS-packages
stored local on a database-server. First I set some global variables, no
issues here, but when I want to set a datasource it says that the
connection
cannot be found, though the name of the connection is certainly present in
the DTS-package.
Any change that some security-settings can make this difference, and if
so,
which security settings?

Part of the code I use:

pkg = New DTS.Package2Class

pkg.GlobalVariables.AddGlobalVariable("name", "value")
pkg.Connections.Item("ConnectionName").DataSource = something

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Interop.DTS Setting a connection

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Interop.DTS Setting a connection - 11-02-2005 , 02:16 AM

Re: Interop.DTS Setting a connection - 11-02-2005 , 11:52 AM