I am writing a custom task (in C#) to add some additional behavior to
the ExecuteSqlTask2 object. I am using the CustomTask and
ExecuteSQLTask2 interfaces , and have the various properties and
methods setup or atleast stubbed out, etc.

I want to write the guts of the execute method. I have a
System.Data.SqlClient.SqlCommand I want to use, but it requires a
System.Data.SqlClient.SqlConnection. DTS has a collection of
Microsoft.SQLServer.DTSPkg80.Connection items, which the SqlCommand
can't use.

I could create a new SqlConnection from the DTS connection properties,
but this doesn't seem very clean, and the password is write only
anyway.

Does anyone have any sample code that uses the package's
Microsoft.SQLServer.DTSPkg80.Connection object directly (any language,
I just need an idea of how its done) ?

The OLE-DB connections used by DTS cannot be consumed like this in managed
code. An OLE-DB connection is different to a managed SqlConnection. To
consume OLE-DB connections you need to write OLE-DB code, to consume managed
connections, well you know already obviously.

If you want extensibility then SSIS is much better, but even then you cannot
consume OLE-DB connections when using managed code like this. You can
however use fully managed connections instead that can do OLE-DB as well.


<jlcaesar (AT) gmail (DOT) com> wrote