|
|
Posted by jags_32 on 11/30/07 17:39
On Nov 30, 11:19 am, aj <ron...@mcdonalds.com> wrote:
> jags...@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
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.
Navigation:
[Reply to this message]
|