DSXchange

Back to INdex and substring. Heres a generic solution as Ken suggested. Can dig out the contents of CSTN_LAST_UPD_DTM no matter how deeply embedded it is. in.Col[INDEX(in.Col,"<CSTN_LAST_UPD_DTM>",1)+Len("<CSTN_LAST_UPD_DTM>"),INDEX(in.Col,"</CSTN_LAST_UP...

The message says that the connection is broken. Do an exact search on those key words. People have gotton this resolved before. Try it out.
Also, when you say you couldnt get the designer to open, what 'complete' error message are you getting?

I dont see the need of doing a REINDEX of your repository just because you are having network issues. Search for keywords "the connection is broken (81002)". It has been covered before. Lets hope you did not break anything.

I say cat all the files and feed it to the bulk loader. 1 million is a piece of cake for a bulk loader. A unix level cat is very fast too.

Uptill now i am fine, very close to loosing my sanity Need a break.

Do an Update on flag with max timestamp as the where predicate.

He did not close it right. Go to the director, cleanup resources and unlock the job. If you need more info, search this forum. Coverd zillions of times.

Advise:
Post in the correct forum.
Search on keywords "please check that all needed libraries are preloaded".

No certifications for Server Jobs and i believe there are entries about the same in previous posts.

Atleast that proves it that i am not going mad. I have 10 multiple tasks going on right now. I wanted to know if i had reached my cpu limit

What changed between yesterday and today? Maybe the database wasnt available. For now its just a guessing game. When the error occurs again, reset the job for more information.

Isnt the OP already in the correct forum, or i am just going blind

I bet they do, its just a matter of utilizing the search engine.

You can also use DSExecute() function.

Different engines, different methadologies. PX has a stronly typed language like C. It is particular about variable meta data which for us is column metadata.