Reg : project level parameters

pandujoy · Post by **pandujoy** » Fri Oct 23, 2009 9:27 am

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

chulett · Post by **chulett** » Fri Oct 23, 2009 9:30 am

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

pandujoy · Post by **pandujoy** » Fri Oct 23, 2009 9:44 am

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

pandujoy · Post by **pandujoy** » Fri Oct 23, 2009 3:27 pm

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

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