Posted by jags_32 on 12/03/07 13:52

On Nov 30, 5:18 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (jags...@yahoo.com) writes:
> > 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!!
>
> I have played with OdbcClient against SQL Server, and it was fairly
> easy to do things that annoyed the ODBC SQL Server Driver.
>
> As "aj" suggested, you could try OLE DB instead. There may not be an
> OLE DB provider for your data source, but you should still be able
> to use MSDASQL, OLE DB over ODBC.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Could you clarify on "MSDASQL, OLE DB over ODBC"? What is MSDASQL, OLE
DB?

Thanks
Jagannathan Santhanam

[Back to original message]