Hello All,
I have a client that is querying our database and it works fine in 64 bit excel. When they try to query it using SQL Server Integration Services it is doing all kinds of funky conversions on our simple data. For Example: We have a Customer ID that is 6 in length (string) and it is trying to convert it to a LOB (Large Object) and the query just returns back a bunch of nulls. Has anyone had any experience with this?
jeff
Hi All,
They were able to fix this. They updated to PxPlus ODBC Version 7 and it then allowed them to change the SSIS Variable type to DT_STR. Once we did this the query came back fine (no nulls).
jeff