ODBC Stage Error

Select Statement:
select column1
         ,column2
         ,[column3 #]
        ,column4
from table

Error Message :
Error Message :  SDE_ext: ODBC Info:  SQLSTATE = 42S22: Native Error Code = 207: Msg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'column3 ,[column4'.

Solution:
the '#' symbol needs to be converted to internal format of datastage.

So, changing the select statement to below will work.

Modified Select Statement:
select column1
         ,column2
         ,[column3 __035__]
        ,column4
from table