DSXchange

Hi,

We have a oracle sequence which has to be used for three target table(Oracle) columns,How could we call oracle sequence and pass the sequence generated value to them.

Thanks for your time

Thanks,
Sateesh

Ray,

Thanks alot for your reply,Could you please let me know how to delete the other post.

Thanks,
Sateesh.M

Hi, I am sorry guys,I posted this in wrong forum sometime back. Could you please guide me on version controlling. I wanted to be away from VC tool as we have disk space problems.Normally in Jobproperties i was trying to change the job version and taking backup of the job ( exporting the job) but whe...

Hi, I am sorry guys,I posted this in wrong forum sometime back. Could you please guide me on version controlling. I wanted to be away from VC tool as we have disk space problems.Normally in Jobproperties i was trying to change the job version and taking backup of the job ( exporting the job) but whe...

Hi, Could you please guide me on version controlling. I wanted to be away from VC tool as we have disk space problems.Normally in Jobproperties i was trying to change the job version and taking backup of the job ( exporting the job) but when i open the dsx file i was not able to see the changed vers...

Arndw\Ray,

Thanks for all your inputs,Now we would be able to get the proper log information.

We used Convert(@VM, char(10), TheString)

Arndw\Ray,

Thanks for all your inputs,Now we would be able to get the proper log information.

We used Convert(@VM, char(10), TheString)

Hi ArndW, Thanks for all your inputs, We would be able to get the full length warning but in between we are getting some junk characters (<FD>) as well the log is not in proper display,as it is giving all the "Environment variable settings: (...)" Whatever present inside this too,it won't ...

Hi, Here is the routine we used ThisJobName= DSGetJobInfo(DSJ.ME,DSJ.JOBNAME) If ThisJobName<>JobName Then JobHandle = DSAttachJob(JobName, DSJ.ERRFATAL) End Else JobHandle=DSJ.ME End StartDate = DSGetJobInfo (JobHandle, DSJ.JOBSTARTTIMESTAMP) BusinessDay = Date() *CurrentTime= Oconv (Time(), "...

Hi, Here is the routine we used ThisJobName= DSGetJobInfo(DSJ.ME,DSJ.JOBNAME) If ThisJobName<>JobName Then JobHandle = DSAttachJob(JobName, DSJ.ERRFATAL) End Else JobHandle=DSJ.ME End StartDate = DSGetJobInfo (JobHandle, DSJ.JOBSTARTTIMESTAMP) BusinessDay = Date() *CurrentTime= Oconv (Time(), "...

Hi all, We wrote a routine to retrieve the log to a file and in our sequence job we used mailnotification to get alerts incase of job failure or warnings.We would be able to get the logs as an attachment to the mail properly but when we look at the attachment we are not able to see the full length w...

Hi,

I have a requ like i need get the return value of function through routine and pass dat value to the target.

Cud anybody through some tips on this,Ihave no idea about routines.

Regards,
Sateesh.M

Hi Friends,

Thanksalot for your inputs.In source we are not getting as null.We are getting in the format of mm/dd/yyyy.

My targetdatabase is oracle.In query i had changed To_Date of price_date then it worked well.I had deleted the routine.

Thanks again for your inputs.

Regards,
Sateesh.M

Hi Folks, Actually from source i am getting price_date as varchar.First i need to ftp'ed the file and then should load into database.But while loading database i need to convert the price_date of string format to date. i had defined price_date as If IsNull(Lnk_Sp_ims_investec.PRICE_DATE) Then '' Els...

Hi Friends, 1stjob:We will parse the xml messages with help xmli/pstage by defining the xpath and will load into different target tables.But for some xml messages we will get some tags in source xml. 2ndjob:Will generate required format message.I am facing a problem while generating this message.For...