Create DTS Connection

#1

Is it possible to create DTS connection(s) in C# and add
them to a DTS package created at run time in code?

// Something like this
DTS.Package pkg = new DTS.Package();
DTS.Connection con = new DTS.Connection();
con.DataSource = ...
pkg.Connections.Add(con);

#2

Yep, that is possible. See the topic "DTS Programming Reference" in SQL
Server Books Online. You have to use the SQL-DMO library, which is a COM
library though.

--
Jacco Schalkwijk
SQL Server MVP

"spenular" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Is it possible to create DTS connection(s) in C# and add
them to a DTS package created at run time in code?

// Something like this
DTS.Package pkg = new DTS.Package();
DTS.Connection con = new DTS.Connection();
con.DataSource = ...
pkg.Connections.Add(con);

#3

Thanks. That helps.

Quote:

-----Original Message-----
Yep, that is possible. See the topic "DTS Programming
Reference" in SQL
Server Books Online. You have to use the SQL-DMO library,
which is a COM
library though.

--
Jacco Schalkwijk
SQL Server MVP

"spenular" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message
news:182901c4ab2a$c4203e00$3501280a (AT) phx (DOT) gbl...
Is it possible to create DTS connection(s) in C# and add
them to a DTS package created at run time in code?

// Something like this
DTS.Package pkg = new DTS.Package();
DTS.Connection con = new DTS.Connection();
con.DataSource = ...
pkg.Connections.Add(con);

.

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

Create DTS Connection

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

Create DTS Connection - 10-05-2004 , 05:29 PM

Re: Create DTS Connection - 10-06-2004 , 08:02 AM

Re: Create DTS Connection - 10-06-2004 , 09:06 AM