|
|
Posted by Erland Sommarskog on 11/30/07 22:18
(jags_32@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, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|