Posted by aj on 11/30/07 16:19

jags_32@yahoo.com 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

[Back to original message]