Description
VPs do not properly assign data length of output parameters. It should be based on known length properties within the transformation, which can be derived from the models that are sourced, or logic defined in the transformation.
For example, a virtual procedure does a "select firstName from mytable", and mytable has "firstName:string(255)". The output parameter for the stored procedure will be "firstName:String(10)". It should be 255 characters in length.