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 SSISProblem DescriptionWe are using 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. (Its treat as NULL). We have checked the VB demo. It is working fine. It is just not bringing Unicode character (NVARCHAR) type column when using SSIS as below:
SolutionsIs 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) | |
|
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.
I would suggest to grab data , convert it to nvarchar using some variables and then push to your output.