I’ve ran into an interesting situation with how SQL Transform behaves.
In the transform we have define a join criteria between tables.
After SQL Transform and the Data Flow are saved, I’m going back into the SQL Transform and code (join criteria) is truncated. I’m attaching an image of how SQL code changes…
We’re running BODS 14.2.5 on SQL Server.
Any ideas what configuration option could be adjusted to resolved this issues.