Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

Thanks.

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.