I am trying to pull in Quickbooks data using an SSIS package in SQL Server 2005. I am having trouble with all the fields that are greater than 4000 characters, as a test I have tried this in the DataReader Source SQL command:
SELECT {fn convert(Memo,SQL_VARCHAR)} as "memostring" from PurchaseOrderLine
This got me past other errors I was receiving but I still get:
"The output column "memostring" had an invalid datatype value (0) set"
yet on the Input and output properties tab I cannot change the datatypes there without getting an error saying the datatype on the output columns cannot be changed.
Right now I have everything installed locally on my computer (Quickbooks, QODBC). Can anyone help? |