Re: Problem importing data from Interbase using DTS

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Anders K. Jacobsen [DK] (none_at_at.all)
Date: 12/12/04

  • Next message: Installing W2003 on BM Infinity 4500R: "Error updating records in ADO disconnected recordset" 
    Date: Sun, 12 Dec 2004 15:31:49 +0100

    > If the ODBC driver does not return control to DTS, DTS looks like it has
    > hung.
    > That indicates a problem with the driver as not with DTS.
    > This problem does not occur with Oracle, Access or SQL Server drivers.

    Strange. Do you know of any Interbase ODBC provider wich is "compatible"
    with DTS import?

    I have tried:

    EasySoft ODBC for interbase
    XTG ODBC for interbase
    FireBird / Interbase ODBC for interbase
    IBProvider ODBC for interbase

    All with the same result. Creates DDL then hang when starting to convert
    data, if one table is choosen it works perfectly.

    Suggestions to ODBC drivers?

    Anders

  • Next message: Installing W2003 on BM Infinity 4500R: "Error updating records in ADO disconnected recordset"

    Relevant Pages

    • Re: Problem importing data from Interbase using DTS
      ... I am using the Gemini Firebird / Interbase ODBC Driver for exactly what you ... I use this driver for a DTS package which pulls about 80 tables ...
      (microsoft.public.sqlserver.odbc)
    • Re: Problem importing data from Interbase using DTS
      ... I am using the Gemini Firebird / Interbase ODBC Driver for exactly what you ... I use this driver for a DTS package which pulls about 80 tables ...
      (microsoft.public.sqlserver.dts)
    • Re: Problem importing data from Interbase using DTS
      ... > If the ODBC driver does not return control to DTS, ... Do you know of any Interbase ODBC provider wich is "compatible" ...
      (microsoft.public.sqlserver.dts)
    • Re: DTS_E_INDUCEDTRANSFORMFAILUREONERROR
      ... Managed ODBC provider to optimize the memory consumed for ... read from the native ODBC driver underneath the managed adapter. ... This call and setting is used when SSIS is reading data from a Managed ...
      (microsoft.public.sqlserver.dts)
    • Re: DTS_E_INDUCEDTRANSFORMFAILUREONERROR
      ... SSIS packages utilizing some 3rd party ODBC ... Managed ODBC provider to optimize the memory consumed for ... read from the native ODBC driver underneath the managed adapter. ...
      (microsoft.public.sqlserver.dts)