DSXchange

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.

Any help on my issue

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.

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.