Knowledgebase
[QODBC-Desktop] How to retrieve character fields which are returned as NULL in SSIS using QODBC
Posted by Jack - QODBC Support on 30 October 2015 09:06 AM

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.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).