I need to import data from a source table in a FireBird database to SQL Server. Our network admin has created an
ODBC connection to the FireBird database. I use SQL Import Data wizard to load data from the source table (Firebird) into a new table in SQL Server database. The import completes successfully, but the string columns (defined as varchar) are all empty.
When I preview the data in the import wizard, I can see the values in varchar columns perfectly. But why don't they get imported?
How can this issue be resolved?