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?
View Complete Post