DSXchange

yaminids wrote:Hi Sasi,

Unfortunately it didn't work. Instead of incrementing the sequence by 1 the second variable just added 1 to the first variable(Max number)

Yamini

If @INROWNUM=1 then v+1 Else v1+1 to v1 should work here.

Hi ravi, i tried using the aggregator.But it is also not giving me the total count.Instead it is giving me a sequence number like 1,2,3...10 again. Thanks, sengs The input to the aggregator would be the sequence number, the ouput would be a single column with the derivation as the count(). Hi Sengs...

More than that you can use Local Containers, which will make it more understandable(visually).

Hi akhiln, After making array size=1,the job was finished successfully.But i need to check the data in the target table to know how the data was loaded. I don't know what's the actual error is......but you can run the job by giving "array size to 1" Changing array size to 1 meaning that y...

Try increasing the size of the field in the job which you are using for this raw field (as error is of the truncation). Did you try using LongVarbinary? and let us know what happened.

If you do not have active-to-active stage interprocess buffering enabled then all the transforms will be executed by one process, and row 2 won't be read until row 1 processed; so there is no need for passing global values between stages. I don't understand why you have this restriction in your job...

Hi Kris9999,

Are you using any longvarchar or varchar field within your job?

Hey Anand,
What about this
This will give all the records of last run.

Where nn is the job no.

There could be many solutions: one would be, Read the whole row of the Sequential file as a column, do a sort, use a transformer with a stage variable having previous row and write the next coming row only if it is not equal to previous row to another sequential file. Copy the new file with overwrit...

Hi ICE, For me job status is -1 when I create a new job and its yet to be compiled. But not very sure on this. Dear Ray, Now I got the jobs name but the DSJ.JOBSTATUS are always -1 even though they are not the same status. May I know what is that??? May I know how to know the staus as -1 is what,1 i...

Dear loveojha2, May I know how to get the job name one by one??? Now your exp will give the series of jobs name.Right?So how to get one by one.I mean how to assign to a variable???I cannot assign to one variable when I run this DSExecute. Or can I use the jobname as the alias of NAME from that quer...

Yes :) and don't forget to detach the job, once you have read the status with ErrCode = DSDetachJob(JobHandle) Hi loveojha2, Thanks for your suggestion.But still i need some suggestion. You give the example to get the jobs name. So there are more than one jobs I will get if I use this.Right?So do I ...

You would need to use Result = DSGetJobInfo (JobHandle, DSJ.JOBSTATUS) which will give you the status of the job. where JobHandle is the Handle for the job returned by JobHandle = DSAttachJob (JobName, ErrorMode) Use erroMode as DSJ.ERRNONE. You can get the name of the jobs from Call DSExecute("...

Hi Annapurna D Kolluri,
Check with your data, are there any duplicated rows coming from your source.

I agree with jenkinsrob. Neither its possible with dsexport nor with dscmdexport.