problem with Column definitions

dodda · Post by **dodda** » Tue Mar 16, 2010 3:42 am

Hi All,

I'm importing table definitions from SQL server tables .And some columns in the table are like below::

Promoted Group ID

Promoted Group Name

And in the transformer i mapped all the source columns to Target columns.
It is not allowing me to map for the columns with space ..Like Promoted Group ID.. And i'm getting the below error

Variable:'DSlink4.Promoted' not defined

Please suggest me how to proceed on this.

dodda · Post by **dodda** » Tue Mar 16, 2010 4:59 am

Any help on my issue

chulett · Post by **chulett** » Tue Mar 16, 2010 5:17 am

Bejeebus, have some patience. You posted at just before 4 o'clock in the morning my time and waited what - an hour - before getting impatient? Chill.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Mar 16, 2010 5:23 am

Unfortunately DataStage does not support blank space in variable names. So you must change the source table or create a view to represent as without blank.