DSXchange

It is expecting format in lower case. %yyyy-%mm-%dd

Are you appending to the file?

Any record that is rejected by the database due to any reason will go down the reject link

As long as you can deploy it as a stand alone, you will be fine.

Yes. Make sure it is a reject link.

No problem. Use another DRS stage to load the same error table. Or collect your rejects in a single file and then load it to the error table in another job or so.

Ken, I dont think he needs to go that far. I think he is looking at the wrong thing and assuming its something else. The response time for an entry to show up in the log is different than its actual run time. Lets see after he clears the logs and clears the PH folder, if he is experiencing the same ...

Ok. I got curious and did some research. It turns out your cannot do ADSI calls like LDAP for INSERT/UPDATE/DELETE DML's. Only select is allowed. This is ofcourse if you are using Linked Server which apparantly you are by your other post.
My Reference.

How are you reading it? Is it a direct connection or via Sql Server linked server? I read data from Active directory using ldap calls but by setting up a linked server. Never tried writing to it. I would be interested in the resolution though.

Getting the message and the actual run times are two different things.
Do me a favour, clear your log file. Clear the &PH& folder while no one is running thier jobs in that particular project. The response time will increase.

Well that might be taking time. I dont know. Check the log for each individual job's start time and end time. See how much time is taking for these extra stages.

I don't know if there's a way to override the default limit for warnings from within a sequence. From looking at some other posts I think it can't be done - but I'd be very happy to be corrected. Go to datastage director, tools, options. Set the warning limit there to overide the default. This will...

Are you doing anything else in the job sequence, like running any routines or os level commands etc.?

Are these sequence jobs running in sequence or some of them are fired off simultaneously?

In px, database stages support reject links. You need a link coming out of your target database stage going into the error table. This way two links will be feeding to the error table. One from the transformer where the null checking is done and the other from your target database stage if the inser...