DSXchange

Are the jobs running simultaneously in the sequence, because that could slow down the jobs. See if thats the same time if they are run one by one. I dont think UVCONFIG settings are a culprit here.

You can use Server functionality in parallel jobs though rarely I used them.Use Basic Transformer in parallel jobs and you can get the Basic routines/transforms work that way.

If you want to purchase the license, yes they will. You cannot download it online...

Search for 'Hardware Requirements' and you will get some inputs

Check the SQL that the Database is generating and see if it matches the columns on Table. This looks like a mismatch of columns.

As Craig Said, It would be an easy way to create a group id say DWTEAM and use it in Notifcation Activity.Dont forget to check box 'Include job status in email'

nvarchar or nchar takes twice the space that varchar or char does to store one character, is it an issue with the length, what happens when you increase it?

In the first job activity use Warning _ Conditional as Trigger and send this link to Routine Avtivity where you can call routine rtLogFatal. or you can set Warning Limit to 1 in the Job Run Properties of Director. You can create your own outine of Type Transform function as below Call DSLogFatal(&q...

In the first job activity use Warning _ Conditional as Trigger and send this link to Routine Avtivity where you can call routine rtLogFatal.

or you can set Warning Limit to 1 in the Job Run Properties of Director.

Did you check the ' Use Custom StyleSheet' in Advanced tab of XML Imput Stage?

What Mansoor said is a good option. If we have a record identifier tagged to header and trailer records, you can grep and get just the detail records. What about skipping the rows if you know the number of header and trailer rows.

FYI you will have to validate your source date before converting it. If your source date can be NULL or Empty or some invalid date then you need to handle that before conversion.

If you want to do it Parallel Jobs you may have to look at conversion functions like StringToTimestamp , StringToDate ..

I hope that should fix the issue.. Let us know !

I assume that you have sorted the data before aggregation