My ADO.NET 2.0 Provider doesn't work in SSIS Import Export Wizard?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Simon - 30 Mar 2007 05:58 GMT

Hi,
I've written an ADO.NET 2.0 provider for our company's database and a Visual
Studio DDEX design time support proivder. Everything works well and the
documentation supplied on MSDN and samples were excellent.

However I can not figure out how to get the SQL Server Integration Services
to allow me to select the "Use this option to copy all the data from the
existing tables or views in the source database" in the Import/Export Wizard.
This option is greyed out (disabled), only the "Write a query" option is
selectable. This is the same for other 3rd party ADO.NET providers, eg
Firebird, MySQL and SQLite aswell ( not to mention ODBC data sources which I
know don't let you select that option because they lack schema info )

There seems to be some "magic" going on in the
"Microsoft.DataTransformationServices.*" assemblies that is SQLServer
specific. I can't find any documentation on the web, or even a mention of it.

Appreciate any insights you can give me,
Simon.

Reply to this Message

Kent Tegels - 30 Mar 2007 14:48 GMT

Hello Simon,

For your connection class, did you implement GetSchema()? E.G., does this
work with your provider?

DbProviderFactory f = DbProviderFactories.GetFactory(...);
DbConnection conn = f.CreateConnection();
conn.ConnectionString = "...";
conn.Open();
conn.GetSchema("Tables").WriteXml(Console.Out);

That's where I'd start if I were writing a tool to discover everything I
could about a generic data provider.

Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels

Reply to this Message

My ADO.NET 2.0 Provider doesn't work in SSIS Import Export Wizard?

Free Magazines