AnsweredAssumed Answered

Why are the 1st 3 characters of the file name missing?

Question asked by mike.hillman@harrisfreeman.com on Jun 6, 2017
Latest reply on Jun 15, 2017 by mike.hillman@harrisfreeman.com

Using a Set Properties shape I set the file name to be a value from a flat file profile.  For example, "Hillman_1040.txt".  The first 3 characters of the file name are always missing, i.e. "lman_1040.txt".  The file name originates from a stored procedure query field that is mapped to a flat file field.  The files names are correct as delivered from the SP.  The resulting text file contains the correct filename as mapped.  The only problem is the actual file name is incorrect when written to disk.  What can be wrong?

 

More Info...

I find that if I pad the values returned from the SP with 3 spaces I get the expected file name.  This is only necessary when using the Set Properties shape.

Outcomes