Knowledgebase
[QODBC-Desktop] Troubleshooting: QuickBooks data return as NULL with SSIS
Posted by Juliet (QODBC Support) on 17 August 2010 07:26 AM

Troubleshooting: QuickBooks data return as NULL(NVARCHAR ONLY) with SSIS

Problem Description

     We are using the QODBC driver for connecting QuickBooks with SSIS. I can able to connect with QuickBooks through SSIS. But Quick books Ex: LIST ID) nvarchar data comes to the destination as NULL. (It's treated as NULL). We have checked in QODBC Support Wizard. It is working fine. It is just not bringing Unicode character (NVARCHAR) type column when using SSIS as below:

Null Value using SSIS.JPG 

Solutions

     Is there any way you can request the data as VarChars and convert it on your end? I think QODBC is returning NVarChars the same as it does for VarChars. (Simple C Strings).

 

Tag: SSIS, SQL Server Integration Services (SSIS)

(198 vote(s))
Helpful
Not helpful
Comments (4)
Daniel Droubie
03 April 2013 12:01 AM
I am having the exact same issue. Is there any additional solutions on this issue?
Roger Dunbar
22 August 2013 09:09 PM
I am having the same problem. I tried the solution of converting unicode (nvarchar) to string (varchar), but I still get NULLs. Any other solution?
Roger Dunbar
22 August 2013 09:35 PM
I just found an article that recommended doing a convert inside of the quickbooks query. For example: select {fn CONVERT(ListID, SQL_VARCHAR)} as NewID from Employee. This worked and now I see the words instead of NULL.
Rajendra Dewani
21 September 2013 07:29 AM
Hi,
I would suggest to grab data , convert it to nvarchar using some variables and then push to your output.
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).