DSXchange

Can you tell more about what you are doing here. Whats the data you are dealing with and whats your job design. A wild guess, are you dealing with xml files here.

What does log say when you reset the job and look for the log from previous run ?

In our case its due to Permissions issue. Check with your DBA

You can use 'Replace' in the Incomplete Column grid.

If you want to get fewer columns that the 16 fields that exisit in the data then you will get this read delimited, may be you should check the box for Suppress Row Truncation Warnings..

You can specify Reject Link in the transformer just before writing to your target.Reject links output rows that have not been written on any other output links from the Transformer stage. This way you can send these rows down the reject link to a flat file. In second job,using the flat file update t...

Thanks Ray and Craig. I wanted to get back to you once I test it against our scenario and you know my answer, that fits perfectly.Thanks for all your inputs...

Thums !!

Thx Craig and Kumar, I think i was confused and also confused you, I have main sequencer job sqDimensionLoad .It has 3 job activities, loadjob1,loadjob2,sqloadjob3 .( All these jobs take #BeginDate# retunred by a routine as input to run each day 10/28 ) sqloadjob3 is a sequencer by itself which has ...

Hello All, I am currently running a job from a sequencer.The Sequencer has a Start Job Activity and End Loop. I have to run the same job for number of days say 20 or more. I am currently passing the a parameter in the start loop and the value is in format YYYYMMDD From -- #BeginDate# Step--- 1 To---...

I remember Ray's quick fix advice to clear the Status file in your Director for this particular job and then running the job again.

Ken,

I think its displaying correctly. The View Data shows both the precision and scale of the decimal data.

ray.wurlod wrote:Welcome aboard. :D

Try surrounding the owner name in double quotes. For example "OPS$OWNER".TABLENAME

what happens when you SET QUOTED_IDENTIFER ON and then use the above example suggested by Ray

ray.wurlod wrote:Welcome aboard. :D

Try surrounding the owner name in double quotes. For example "OPS$OWNER".TABLENAME

what happens when you SET QUOTED_IDENTIFER ON and then use the above example suggested by Ray

Do you have any other stages like IPC or Link Partioner in your job design. Once had a similar problem and removed the IPC and it performed OK. Another option I found in the forum is to check inter process under Enable row buffer option and increase the time out-say 60sec. HTH see I am working in p...

Do you have any other stages like IPC or Link Partioner in your job design. Once had a similar problem and removed the IPC and it performed OK. Another option I found in the forum is to check inter process under Enable row buffer option and increase the time out-say 60sec. HTH see I am working in p...