DSXchange

Though Aggregator, youc cannot Sum accross Columns. As suggested use Transformer for that case.

Has "Enable job administration in Director" option been checked?
check the permission for DSParams files.

Nice to see Craig back from Vaccation. Let me wait, if he has some updates on this.

This will be one of the reason for this error. if diognised well, and found out noting else could be the reason, you can increase this factor.

Yes.

If you have enabled the Check Point restart option you can just rerun. So that the job will start at the last check point. Look at the Job properties tab in your Sequence. Search for the same.

Execution mode is decided by the Cofig file you use for that particular job at that point of time. So dont correlate it with Scheduling.

Your metadata should have atleast one key column thourgh which the "Update existing rows or insertnewrows" logic can be performed.

Use Trim() function. Or Convert() if you think, 0's will be only in leading end.

Not a job for each transformation.

Vincent's blog is out as well.

Thank Kim.
I dont guess, Cron has failed. Because, there is a single log entry at the scheduled time.
This is very similar to this issue stated by Craig in this post.
http://dsxchange.com/viewtopic.php?t=85 ... c92ba1961b

The topic name is "DS Job Schedual" (I dont this the link will work even if I add www to it)

Are you sure that you are doing a lookup over the transformer
Change the name of the Filed name in either one of the like from NAME, ID and XYZ to something else.

vsi wrote:Yes I am doing that right now :D.

But as well want to have old project name. For time being I will continue to work on a new project, then later on try to retain the old name, by removing the old project.

Thanks

You got the safest approach. :D

Check the columns and the keys mentioned in the Sort stage. If you were trying to type the column names, avoid it and try with the Datastage Click event.