SSIS

[Jeffrey Ferreira]

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

[Jeffrey Ferreira]

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