I have a table which I am importing which contains leading spaces in some of the fields. I desire to retain these leading spaces for the purposes of formatting, but when I perform the following load, the leading spaces appear to be stripped from the fields in question.
The load statement follows reading from a SQL Server table:
GLReportLines: SQL SELECT * FROM dbo.qvGLReportLines;
Is there an option that I need to set to retain leading spaces?