Hi all, Hoping that someone can offer an easy solution to this but I am sure that is not going to be the case, I have been given an Interbase database which they would like to import the contents in to SQL Server 2008, I was hoping that under 2008 SSIS there might have been some way of setting this up as a data source and importing it that way, something similar to a access database file or excel file. It seems that I am going to have to install some software to host the database and then do the import from there, sure there must be an easier way as at the end of all this they want to connect something to the main interbase database and pull everything across so I am reluctant to have to doing 2 different things to test all this, any suggestions? Thanks P

You need oledb providers for interbase. Check this linkNitesh Rai- Please mark the post as answered if it answers your question

Hi Nitesh, I had a look at the link that you sent me and installed Advanced ETL Processor from the download on the site, the file is just stored now in a folder on my pc, when I try to connect to it through Connection Manager in SSIS I get the Error TITLE: Connection Manager ------------------------------ Test connection failed because of an error in initializing provider. [dbobj] Loading the dynamic library "gds32.dll". The specified module could not be found. WIN32 Error: 0x7E ------------------------------ BUTTONS: OK ------------------------------ Do I need to get the file from the people that originally sent me the Interbase Database and put it in to the same directory as the original .IB file to allow me to connect to it through SSIS? Thanks Phil

Hi Nitesh, Thanks for the help with this, I finally managed to sort things out and get my process working, thanks for the help. Phil