Importing data from a Firebird Database into SQL Server 2008

• shanewiso

  SSC Eights!

  Points: 805

  More actions

  March 1, 2011 at 1:20 am

  #232761

  Hi,

  I am faced with some work coming up where I will need to on a daily basis extract data from a firebird DBMS into a SQL Server Data-warehouse.

  This will need to be a scheduled event that will need to occur every morning. Currently the data-warehouse only imports data from other sql server instances using linked queries and the sql agent to trigger the schedules set.

  I could develop a service that would sit in the middle of both DB's and act as the data-pump.

  Is there any other way using SQL Server itself to connect to the Firebird db, execute some sql to get the data and clean it, then insert the data into the sql server warehouse.? I havent really delved into sql data transformation services, maybe this might be the way to head... not sure... any advice would be appreciated.

  Thanks. 🙂

• craig.booth

  SSC Journeyman

  Points: 95

  More actions

  April 10, 2012 at 1:01 am

  #1471080

  Hi,

  Did you get any help on this?

  I have to do the same thing and I'm having all sorts of trouble.

  Regards,

  Craig

• Igor Micev

  SSC-Dedicated

  Points: 33109

  More actions

  April 10, 2012 at 1:40 am

  #1471090

  Hi,

  SSIS package may be a best solution.

  Regards

  IgorMi

  Igor Micev,My blog: www.igormicev.com