Does this work any better?
Set UserName='#getnames.firstname#'+' '+'#getnames.lastname#'
Also, the maximum Bytes per row for SQL Server is 8060, so if
the total number of bytes in all of the columns exceeds this value,
you will get the error (excludes columns of text and image, etc.)
Phil