DSXchange

Hi Frank,
Im using like below
#parmDataSource#
#parmUser#
#parmPassword#

Error: ORA-01017: invalid username/password; logon denied
is the error message I received

Thanks Craig
Yes, I may need to cut and paste the required user variable activities to new job.

I'm not suppose to hardcode the password inside the STP stage. It should be passed from sequence job. So I used the corresponding parameter name in the place of password, which is not getting accepted by this stage.

Hi,

I'm using Stored Procedure stage to call Oracle SP. In the data connection,
I'm able to pass the parameter for Data source and Username. However, I'm unable to pass the parameter for password as it accepts encrypted format.

Can you suggest the way to accept the parameter?

Hi, I have a sequence job1, where I called uservariable activity to receive a value from execute command activity and pass it to one of the job activities. I need the output of same uservariable activity to be used to sequence job2 as well. Is there anyway to be reused, instead of redesigning activi...

My 'Jobs' folder has too many sub folders. I'd like to create same folder structure in my version control tool. Is there any way get it, instead of manual creation?. If my server is also resides in windows, will it be possible?

Can we get the Client Repository structure (Jobs folder structure) from DS server (unix)?

Hi, My source is fixed width file with below format. H00014700 Ddewuuwq T00014720 I have below scenarios for rejections. If input file falls under any one below, then I have to update another table with file name and reject reason 1. Empty file (zero rows) 2. Only header and trailer 3. Only Detail 4...

Hi, I have a file with variable length of records.Maximum length is 2000 bytes. I want to convert the file to fixed width. ie., I want to convert all the records to equal length of 2000 bytes by adding spaces. I have shell script for the above conversion, however, the converted file occupies more mo...

Any help?

Regards,

Hi,

I'm able to save 2 jobs with same name by changing the cases.
eg., job1- TEST, Job2- Test in test environment in DS8.5.
where as in UAT environment, I could not do the same.

Any idea?

Regards,

Yes. It still occurs. My job has only DRS stage and dataset

Regards,

My apology. Let me explain you clearly. My job is simple which extracts data from table A (SQL server DB) and do a look up with table B(TERADATA) and load it to Dataset. SQL server DB is connected through DRS stage and TERADATA is connected through TERA DATA stage. It works good, If I replace DRS st...

yeah.... when I tested with DRS connector stage, the jobs works fine.
There is no issue with teradata stage. So I was under assumption that, It is a issue with DRS stage.

Regards,