That worked!! 😀 Switching it from a Ragged Right to Delimited Flat File Destination has prevented the data from being padded with extra trailing spaces, for the type 1 and...
Yes, it appears as though the space is being added when written to the Flat File Destination. Right now, my file format is Ragged Right. I will try your recommendation...
I copied the data from the Data Viewer, between the OLE DB Source, and the Flat File Destination, and, using ConText, I am able to determine that the column length...