Knowledgebase: Microsoft Products
[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 a Unicode character (NVARCHAR) type column when using SSIS as below:

Null Value using SSIS.JPG 

Solutions

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

 

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).