Re: SSIS is pathetic with ODBC connections ...

jags_32@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

.

Relevant Pages

  • Re: SSIS is pathetic with ODBC connections ...
    ... fetch data from a Double Byte Progress database and the "DataReader ... that SSIS is a totally rewritten version of DTS. ... I have played with OdbcClient against SQL Server, ...
    (comp.databases.ms-sqlserver)
  • SSIS is pathetic with ODBC connections ...
    ... fetch data from a Double Byte Progress database and the "DataReader ... that SSIS is a totally rewritten version of DTS. ...
    (comp.databases.ms-sqlserver)
  • Re: The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
    ... I just tried installing the new driver, and found it doesn't help me import from Access, so I guess something is still missing like the asam driver issue in the article. ... I got my import to work, but using what I consider a kludge approach. ... I then saved my SSIS package to SQL and changed the job step from SSIS to Operating System type. ...
    (microsoft.public.sqlserver.setup)
  • Re: SSIS is pathetic with ODBC connections ...
    ... fetch data from a Double Byte Progress database and the "DataReader ... that SSIS is a totally rewritten version of DTS. ... I have played with OdbcClient against SQL Server, ... you could try OLE DB instead. ...
    (comp.databases.ms-sqlserver)
  • Re: SSIS Pulling Data from an AS400
    ... Is there anything on the driver itself that you can set when creating the connection manager. ... You may be able to tweak the "DefaultBufferSize" and "DefaulBufferMaxRows" on the Data Flow task to see if this helps. ... FetchBufferSize in SSIS? ...
    (microsoft.public.sqlserver.dts)