exposing proprietary data to SSIS (Newbie alert)

I believe the way to do it these days is to inherit from the newer DbConnection, DbCommand base classes that than the older interfaces.

You then need to register it, and the simplest method is to go straight for machine.config, and edit the DbProviderFactories section, adding your new provider.

<system.data>
<DbProviderFactories>
<add name="My Data Provider" …/>...

This will allow you to select your provider when creating a new ADO.Net connection. The data reader source can consume this connection for example.

There are limitations to this, and sometimes it may better to write your own connection manager, source and destination components.

I cannot seem to find a link right now that covers the development side of the Db factories world, but this is about using them and covers much of the supporting info-

http://www.codeguru.com/csharp/.net/net_data/sortinganditerating/article.php/c10487/

DarrenSQLIS at 2007-9-9 >

I had stuff that did the 1.1 interfaces, but found i had to "upgrade" to the base classes to get it to be found correctly. A couple of links that cover more about it-

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadonet/html/genericdacode.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/vsgenerics.asp

DarrenSQLIS at 2007-9-9 >