Returning string from db table to DW

[docky5]

HI,

I have a SQL table which helds a long string(more then 256 chars). When the SP retrieves the string on the report I can see only a part of the string not the whole. The variable is defined in the PB as string (1000).
In the Query Analizer when I selected that table for the string first it showed only 256 charter from the string, after I changed it to show 1000 I could see the whole string. Can it be the problem, that SP can pass only 256 char?

Thanks the help in advance.

 

[thekl0wn]

What version of PB are you using? What DBMS? And what's the connection string look like on the transaction object?