Hi All,
Actually i am new in the field.I am facing the problem ... when i am using ORACLE OCI for transfer data from data base to Flat file.
It gives the Error LIke :
1: Fatal-- Oracle_oci_0 userid is a required stage property.
2:Warning -- Attempting to clean up after about raised in stage oracle_oci .
Please give me proper suggestion to avoid this. I will be thank ful to u.
About Oracle OCI
Moderators: chulett, rschirm, roy
Your problem is fully spelled out in the Fatal error message.
As one would expect, the OCI stage needs three pieces of information to connect to an Oracle database - a Data Source Name or DSN (aka SID), a User ID and a Password. The message tells you that you haven't supplied a User ID in the General properties of the stage.
Suggest that before running the job you check that you can 'View Data' from the stage.
As one would expect, the OCI stage needs three pieces of information to connect to an Oracle database - a Data Source Name or DSN (aka SID), a User ID and a Password. The message tells you that you haven't supplied a User ID in the General properties of the stage.
Suggest that before running the job you check that you can 'View Data' from the stage.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers