| eprobst 2006-01-26, 4:58 pm |
| Hello Dave!
I had the same problem. The problem is that the OLE DB provider for ODBC is
not supported by SISS.
Although it does work with migrated DTS-Packages from SQL Server 2000, if
you don't change anything.
If you try to use one of the Connection Managers for the ODBC-Connection
which were created during the migration to create another data flow, then you
will get the following error message:
"The .Net Framework Data Provider for OLEDB (System.Data.OleDb) does not
support the Microsoft OLE DB Provider for ODBC Drivers (MSDASQL). Use the
..Net Framework Data Provider for ODBC (System.Data.Odbc)."
So what I tried is:
Create a new ADO .NET Connection Manager, choose .Net Providers\ODBC Data
Provider, then choose the ODBC-Data Source form the drop down list.
Then create a new Data Reader Source in the data flow. There you can enter
the SQl_Statement
Maybe this helps you.
For my ODBC-Driver this did not work, but that is probably due to some
misunderstandings between the .Net Provider and the ODBC Driver.
I had to link the tables in an Access-Database and then point the data
sources to the access-Database.
Regards, Elke Probst
"Dave" wrote:
> Does anyone know why the "OLE DB provider for ODBC" won't show up in my
> Provider list when I try to set up a New OLE DB Connection?
>
> I do have this provider installed.
>
> Is my only option to write a script in order to connect to an ODBC
> destination?
>
> Thanks.
> Dave.
>
|