DSXchange

Hi!

I check all possibilities and I know surely that The reading hash file is slowing down .
I try HFC . I doesnt help too.


Any ideas . What parameter may influence the reading speed ?

I need help !

when I run Job Sequence I want to compile each job with routine or somthing if it isnt compiled . Is there is way to do this

I searched and didnt find answer for my questions

If your system is 32bit The hsh file size limited to 2.2 Gb.
Multiply 3100000 to size of each row you enter the hash file.

Does it exceed 2.2 GB ?

Hi ! I dont find some properties of dynamic hash file i see in Hash File Calculator : For example - Separation . How it named in options of Dynamic hash file. What is property called Large record ? If i have only 100 bye rows if the decresing the dafult value of 1628 will increase the perfomnace ? W...

May be you can post the code extracting non-key field from hash file

Thank in advance

Hi !

I need to set Job Parametr to value from database

How i can do it ?

I want to use DSLogEvent function within Routine Activity of Job Sequence. Which rouitne I need to use :
Transform , Before/After or any other .

If I need to do DetachJob this case . It seems the sequence is stuck in this case

Hi !

Help me please

I want to read Log I seee in Ds Director and catch all events that contains definite string in event description and write to table

Hi ! I have a question related AGregator stage I have aggregator and ODBC stage for writing. when any error during writing for example : The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value. the job is failed . Why because of one row ? I think A...

I want to go on on Warning . Only Failed status can do STOP . But Warning do STOP . That the problem.


Thank you but I still need help

I dont think so . I want to change it inside job wis BASIC code i think not throught DS GUI

I get in next row too the row :

LoadTfs..Transformer: LinkToCustomer:Row 3699 was rejected by OLE DB provider.

I have question for users of MS OLE DB stage
For row
that failed to enter the DB returned :
LoadTfs..Transformer: OLE DB provider error HRESULT=0x80040e21.

How OI can catch this row in Transformer and write to Errror table.

Hi ! I have problem with job sequense. I put to Job activity 1 and Job Activity 2 From Job Activity 1 tere are two link : to Job Activity 2 (Trigger - OK - (Conditional)) and to TerminatorActivity(Trigger - Failed - (Conditional)) The problem is that when in Job Activity I get warning The sequence s...