TI Update String Cell Values SqlServer Query 256 Char Limit

[WilliamSmith]

Hi all,

I have a process that takes a field from SQL Server and uses CellPutS to insert the value into a cube intersection.

The limitation I've run up against is that if the string length in the field from SQL Server is > 256 characters it gets truncated.

I've confirmed that the data from SQL Server is providing the full text field data to TM1, so the concern is past the "ODBC" interface.

My work-around solution is to "chunk" the text field into multiple 256-char fields via SQL at the point of ingest in Turbo Integrator. Now, in order to prevent loss of leading and trailing spaces, I also needed to convert normal spaces to non-blanking spaces, then convert them back to normal spaces downstream.

Wondering if there's a more elegant way to get this to work?