I expected that setting the Modify Rowset task's Size parameter would truncate values in the rowset, but that doesn't seem to be the case. Setting the Size parameter to 30 doesn't seem to affect the output at all as values greater than 30 are still written to the output file. What is the purpose of the Size parameter?
I can make this work using the Substring Function, but I have to test for string length greater than 30 characters or the function errors, e.g.
Code: Select all
${If(Length(var) > 30,Substring(var,1,30),var)}