DSXchange

Hi,

I am facing a strange error.....I have a job and when i am trying to load data from Informix database through user defined parameters (DSN/USE/PASS) the job is getting aborted ....but when i am trying to run the same job using job level parameters i runs clean. Suprisingly i just added user defined variables for only DSN/USR and hardcoded the password inthe ODBC stage it runs fine....Looks like something is going wrong at password field.

Not sure if anyone had faced such a problem. Please let me know what might be the reason .....

Thanks in advance

What is the abort? Is your password encrypted and if so, does it work as an environment variable when not encrypted?

Thats true....When i am provided password field as encrypted the job gets aborted and fails...But i put as string it runs fine

I was being a fool......#$variable#.......

Look like a bug in odbc stage...it pulls only $variable....