Re: Problem importing data from Interbase using DTS

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Joseph Geretz (jgeretz_at_nospam.com)
Date: 12/14/04 

Date: Mon, 13 Dec 2004 23:09:59 -0500

Hi Anders,

I am using the Gemini Firebird / Interbase ODBC Driver for exactly what you
are trying to do. We're slowly converting all our clients from Interbase to
SQL Server. I use this driver for a DTS package which pulls about 80 tables
from Interbase source into our SQL Server target database. However, I use an
individual Transform Data task for each table. It's a nightmare to maintain
as we evolve the database structure but it runs really nicely, with multiple
TD tasks executing in parallel.

http://www.ibdatabase.com/
https://secure.shareit.com/shareit/checkout.html?productid=148695

Hope this helps,

Joe Geretz

"Anders K. Jacobsen [DK]" <none@at.all> wrote in message
news:ulIOTdF4EHA.2404@TK2MSFTNGP14.phx.gbl...
>> 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
>
>
>

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.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: 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.odbc)
  • 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)