how do we handle column names beginning with numbers in MSSQL
1_pymt_date is my column name present in the MSSQL dataobject. My dataflow is failing when I’m using this as my column name.
When the SQLSERVER attributes are having numbers in the attribute names, then we can choose the strict name option as YES present in the Dataobject level. Then try to run the dataflow or jobflow.
Script: