Re: SSIS is pathetic with ODBC connections ...

On Nov 30, 5:18 pm, Erland Sommarskog <esq...@xxxxxxxxxxxxx> wrote:
(jags...@xxxxxxxxx) 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...@xxxxxxxxxxxxx

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
.

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)
  • Unable to Create a Maintenance Plan
    ... This is SQL Server 2005 standard edition. ... We have SSIS ... --- An OLE DB error 0x80004005 ...
    (microsoft.public.sqlserver)
  • RE: Tool for migrating from one db schema to another?
    ... even schedule it to run using SQL Server Agent on regular basis (SQL Server ... Sommarskog has mentioned SSIS does not come with the Express edition. ... database would be the key. ... a few hundred tickets to migrate to the new system. ...
    (microsoft.public.sqlserver.tools)
  • Re: How to get job result from sp_start_job
    ... Thanks, I did not include all the code, but the program invokes sp_start_job ... to run a job that is set up in the SQL 2005 SQL Server Agent. ... if executing and 4 if idle. ... The return value I get is only whether or not it was able to start the SSIS ...
    (microsoft.public.sqlserver.dts)
  • Microsoft Bug
    ... I've had the same problems when using ssis to AS400 with HIT driver software. ... OLE DB Command usage when updating data on AS400/DB2 ...
    (microsoft.public.sqlserver.dts)
Loading