Hello,
i use a CTP of Integration Services 2005 at the moment, to test one of our
ole-db providers. This provider works almost perfectly in DTS within
SQL-Server 2000, but if i try to create a named query in integration
services, i get an error, that my provider-string doesn´t match the ole-db
specifications. I can browse data within a dataview, but i can´t crate a
named query.
What does this error mean ? I already found out, that this error doesn´t
necessarily mean, that my provider-string is wrong. I got this error, if
some properties weren´t supported by our provider, too. Now i added all
necessary properties and i still get the error, but as far as i can see from
within the provider´s trace-output the error comes up at a different
position. What can i do ?
Are there any documents about the mandatory interfaces, schemas and
properties that must be supported/implemented in our provider as it was
documented with DTS in sql server 2000 ? Where can i find these ?

regards

max

Which CTP are you using Max?

Which OLEDB provider?

Named Query? Do you mean you have done this.

Create a datasource
Created a data Source View based on the Data Source

In the Connection properties of the OLEDB provider you specified the DSV
and "named query"

You could try writing your own connection manager for SSIS.



Thanks

Allam


"Max Berghammer" <max.berghammer (AT) cubeware (DOT) de> wrote

Hi Allan,

my integration services-designer version says 9.00.1314.00. I can´t tell you
the CTP Release-Date, as i don´t know where to look for it...The Package was
installed on my machine by one of my colleagues and the guy cancelled his
job last week and went to microsoft germany...bittersweet irony The OLEDB
provider is one of our custom providers for SAP. It was developped by me
some years ago and it worked perfectly within DTS 2000. Now we wanted to
build a service release for this provider for SSIS, so i first tested it
with this CTP. I can create a datasource using our provider and i can create
a datasource-view. That works fine. But then i wanted to create a Named
query in the datasource-view and got this annoying error immediately after i
clicked the entry "New Named Query..." in the context menu of the
datasource-view´s design-view. Now i thought, ok, no problem, seems like
SSIS-Designer needs some Properties, Schemas or Interfaces that are not
supported/implemented by our provider. So i found out, the "New Named
Query"-Wizzard additionally needs the OLEDB-Properties DBPROP_GROUPBY,
DBPROP_QUOTEDIDENTIFIERCASE and DBPROP_ORDERBYCOLUMNSINSELECT. No problem -
I implemented these in our custom provider. But i still get this
error-message complaining about the format of the provider-string.

From the trace-output of our provider i can see, that the error is being
thrown a little later than in my former tests before i implemented the
additional properties.

When i first developped the provider some years ago, using Visual C++ 6.0
and ATL OLEDB Provider Templates, there was an article in the MSDN
Help-collection describing the mandatory interfaces, properties and schemas
a provider has to implement/support so that it can be used within DTS. Is
there a similar article for SSIS ? Especially for the SSIS-Designer within
Visual Studio 2005 ? This would be a real help for me, as i can´t find
anything about this on the net...ok, it´s a quite new technology, so this is
no wonder...

The problem is that there are so little developers on the net which build
custom oledb providers and the docs concerning this point only describe the
basics how to build a provider, how to extend it that it can be bound to the
microsoft datagrid control, etc. These things are already done...But how can
i get it working within SSIS-Designer ?

thanx in advance

regards,

Max Berghammer

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag
news:OesF94ryFHA.2348 (AT) TK2MSFTNGP15 (DOT) phx.gbl...