DSXchange

Hi Friends,

I got one issue with password seeting in paramter. When I ran the job, i got an error like

Incorrect dboption list; it failed on Expected "," or "}", got: "@", line 1

I don't have any special characters in my password, using only characters and number like Abcd09.
I tried in this forum through Search option, but could not find the solution.

Please help in resolving the issue.
thanks in advance.

Details, please... Database? Stage? etc

Hi Chulett, thanks for your reply.

My source and Target stages are Oracle db.

my job disign is like : Ora db stage->Transformer stg->Ora db stage

Thanks in advance.

Which "Ora" stage, exactly? And how are you passing in the password?

Hi Chulett,

we are using Oracle EE Stage as source and target. And we difined a environment variable at Project level and given the password to taht and using that variable as parameter in our job through Parameter Set. The password is defined in Encrypted mode.

Thanks in advance.