Hi I'm trying to export data from a SQL Server View to a CSV file.
I have been able to do this using the 'Table Input' and 'Text file output' steps. How do I remove the white space to the right of the last column in the CSV file? I have tried Using RTRIM() in my View SQL and tried the Trim Type option in the Fields tab of the 'Text file output' step. Thanks Rob
