DSXchange

Hi,
Check with your DBAs for the exact precision the date column have (it might not had miliseconds)
and transform the input date accordingly.

IHTH,

Hi, Original Request: I have two input arguments x and y. If x=2 or 7 then y should be >=0. If x is otherthan 2 or 5 then y shoud be >0. Correcting Ray's code x = Arg1 y = Arg2 IF x = 2 OR x =7 THEN IF Y >= 0 THEN Ans = @TRUE END ELSE Ans = @FALSE END END ELSE IF x <> 5 And Y > 0 THEN Ans = @TRUE EN...

Hi,
in a transformer you can put a reject link or thest the REJECTED variable or test for the RDBMS return code in some cases.

a search will pop up all the info you need it was covered before.

IHTH,

Hi, search for existing posts on this subject. there are several ways including: 1. rebuild new table and make a switch 2. load the values and keys to a temp table then run an update sql with join on the 2 tables. p.s: if DS was the cause for your slow performance in update you would not have got be...

Hi, when you use dsjob to get job's info you get the last run info. if you need the info for the run prior to the current you can query this info before running the job of log it some where after each run. If you mean only get that info without all the other info, you need to check if an option exis...

Hi,
did you check using 64 bit hash file to verify the 2GB limit?
(search on how to do it in this forum if you need to)

Hi, Do you only need to build the control file/s from existing files or ones you build in an ETL proces? How do you define slow? it should be relative to task and resources at hand. Tricks for getting best performance include IPC stage to make sure a process gets max CPU doing a single task like onl...

Hi,
at first glance it seems that DS can't find the specified directory/ies in the configuration file you mentioned for node3.

IHTH,

Hi,
are you using in the hash file options delete and create or clear? - clear might cause the file to be corrupted along time.

is it possible your reading and writing to the file simultaniously while locking it for updates?

Hi,
are you using delete/create on that file or simply clear/insert along time?

is there an ipc stage there?

did this job crash recently?

Hi,
the starting point should be a nested condition stage having triggers that start the job asctivities depending on the conditions you mention.

IHTH,

I can't remember what happens if let us say root user gives recursive full access to everyone eventually effecting on the project directory. do check it. build a simple job control with 1 line: Call DSLogInfo("test","Testing:") promote that job and see if all have access to that job? (that should te...

Hi and Welcome aboard ,
As Ray mentioned they simply provide different functionalities, so theres (is this gramar correct Ray?) no real question of pros/cons, since they don't "compete".

IHTH,

I think it should be equal to the number of promts you expect to have. Some how it might also have to do with hte telnet configuration on the server you try telneting to. alas I think you might want to check with your windows administrators for that. Maybe others have more valuable info on this

Hi, several things: 1. what is the method of transporting jobs to the production system? 2.Did you verify the users which are not suposed to have access really don't? First make sure only proper group/s have access in the DSAdministrator. Then login to the system as the user/s you think should not h...