How to retrieve character fields that are returned as NULL in SSIS using QODBC

Problem:

Using SQL Server Integration Service (SSIS) and QODBC, All character fields are being returned as NULL.

Solution:

Please use the function CONVERT to convert the data into SQL_VARCHAR type to fix this problem.

You can use the CONVERT function in SSIS like this:

{fn CONVERT(ColumnName, SQL_VARCHAR)}

Here is an example of how to use this function in a linked server:

Syntax: SELECT {fn CONVERT(ColumnName, SQL_VARCHAR)} FROM LinkedServerName...TableName

Example: SELECT {fn CONVERT(ListID, SQL_VARCHAR)} FROM QODBC...Customer

Please note “QODBC” is the linked server name on our machine. Please replace it using your linked server when testing it on your end.