Hi,

I need to add a new managed .net provider to the list of available
connection providers in DTS for SQL Server 2005. Is there a reference on how
to do it?

You are probably better off in the 2005 Beta Newsgroups but yes this is
possible and there should be documentation in the 2005 docs for you.


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Houssam Zeina" <HoussamZeina (AT) discussions (DOT) microsoft.com> wrote

Create a class that inherits from ConnectionManagerBase, override what you
need, add your own properties if required and apply the DtsConnection
attribute.

Drop the assembly in C:\Program Files\Microsoft SQL
Server\90\DTS\Connections and the GAC.

You connection manager will now be picked up next time you start BIDS.

What I am unlcear on is what this will give I think you will need to write
your own consumers as well.


--
Darren Green
http://www.sqldts.com

"Houssam Zeina" <HoussamZeina (AT) discussions (DOT) microsoft.com> wrote