Blank columns when importing columns through SSIS from Interbase

• alhajirr

  SSC-Addicted

  Points: 440

  More actions

  December 5, 2014 at 3:16 pm

  #299219

  I have a scenario where I need to import data from an Interbase database to SQL Server nightly. I am using SSIS 2008 to create the package. I installed the correct Interbase ODBC driver as I was able to create a linked server and pull data without issue.

  When I create the Data Flow task, I selected ADO.Net source to connect to Interbase. After selecting the table I want to import, I hit preview and see all my columns.

  However, when I send the source downstream either to some transformation step or directly to the destination, all the varchar columns are blank. I tried researching everywhere but I can't figure it out. The source tables are unicode so the destination columns are nvarchar. However, when I use a Data Viewer right after the source step, those varchar fields are blank so I know it's not the destination table that's the issue.

  Any ideas of how I can resolve it?