DSXchange

we are going with Execute command activity.

Hi,


I am also passing the job name at the run time.
But have not yet discussed about using the execute command activity instead of routine activity.

Hope fully will finalize on that today.


Thanks,
Samyam

chulett wrote:Outside of a dog a book is man's best friend
Inside of a dog it's too dark to read

super funny

PhilHibbs wrote:Do you need to specify -wait in the dsjob command?

Hi,

Yes we are using wait and a lot of other parameters as well. I have just given a sample.

alright craig. will discuss with the team and give you an update.

But i am just curious to why that error is coming.

Hi craig,

Its the built in ExecSH routine.

the argumet is "dsjob -run PROJ JOBNAME"

The job names ( the invocation id ) and parameters are decided at run time.

Hi, I am triggering a job from sequence using a routine activity. inside the routine activity i am use ExecSH. and passing teh dsjob command as input argument. the job runs and teh jobs log is also fine, but the log of the sequence says. JobControl (ExecSH): Error when executing command: dsjob -run ...

Hi Pandeesh,

I think the source and reference should be interchanged when you are trying that.

try this unix script


while read record
do
cat srcsam.txt | grep '$record' >> tgtsam.txt
done < refsam.txt

Thsi should work

at the source do a time to string and at the target do the opposite(string to time).
It should work.


I had faced the same issue
Doing this has solved the issue.

Also can you post the table structure of the target table here.( the time columns )

Hi ,

What is the error message you are getting.

Hi ,

This can be achived in transformer stage using stage variable.

This has been discussed a lot of times

viewtopic.php?t=140653&highlight=

Hope this helps

Hi Mandyli,

Try something like

sed '1s/NameID SalaryId/Name.ID Salary.ID/' Outputfile > OutputFileTemp

This should help

Hi Craig,

Are you asking me to explain a bit more.
Or Are you asking the guy who posted the topic.

Regards,
Samyam