Re: SSIS is pathetic with ODBC connections ...

On Nov 30, 11:19 am, aj <ron...@xxxxxxxxxxxxx> wrote:
jags...@xxxxxxxxx wrote:
We have spent days trying to perform a proof of concept and I am
dissappointed with SSIS to say the least. We are trying to connect and
fetch data from a Double Byte Progress database and the "DataReader
Source" using a ADO .NET ODBC provider does not work! I understand
that SSIS is a totally rewritten version of DTS. What annoys me is
that this functionality used to work in DTS and does not in the much
talked about SSIS!! Will someone in Microsoft start listening to
customers instead of gloating on useless features. SSIS is a total
waste if it cannot connect and fetch data from a wide variety of
source databases!!

In my experience, ODBC is a bad choice. It is slower than dirt and
a very old technology. I use SSIS w/ an OLE DB driver (both DB2 and
SQL Server) and have been very impressed with its functionality.

Can you use an OLE DB driver?

aj

I totally agree with you that ODBC is old technology, however, we have
no choice since that is the only way we can connect to the SOurce
Database.
.

Relevant Pages

  • Re: Sybase Source. What "data flow source" to use?
    ... when I right-click over a SQL 2005 ... database and select Import Data, the list of providers does not include ... either A) the list of datasources defined in ODBC Datasources on my computer, ... I've been so excited about SSIS and telling my co-workers how ...
    (microsoft.public.sqlserver.dts)
  • RE: 2005 SSIS Package using ODBC
    ... This seems to be a compatible issue between ODBC driver of the datasource ... What is the type of the database you want to connect? ... 2005 SSIS Package using ODBC ... >designer, I added a connection based on the DSN, and again it tests fine. ...
    (microsoft.public.sqlserver.dts)
  • Re: Sybase Source. What "data flow source" to use?
    ... I've been so excited about SSIS and telling my co-workers how superior ... I added an ODBC connection manager that works great when I do an 'execute ... query of the Sybase database in the 'Execute SQL Task'. ... Then I add a 'data flow task' and go to the Data Flow tab. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS_E_INDUCEDTRANSFORMFAILUREONERROR
    ... SSIS packages utilizing some 3rd party ODBC ... Managed ODBC provider to optimize the memory consumed for ... read from the native ODBC driver underneath the managed adapter. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS_E_INDUCEDTRANSFORMFAILUREONERROR
    ... Managed ODBC provider to optimize the memory consumed for ... read from the native ODBC driver underneath the managed adapter. ... This call and setting is used when SSIS is reading data from a Managed ...
    (microsoft.public.sqlserver.dts)