DSXchange

Doesnt it spit out a warning if file doesnt exist for the very same reason ?

Do you need to wait for file or just check if it exists or not? If the former then look into narasimha's suggestion. If the latter then search this forum. I posted a routine, a simple one, a while back that returns a true or a false for file presence and absence respectively.

It feels nice when posters like you appreciate the work done at dsxchange. And feel free to throw in your opinion on whatever post.

Read my previous reply again, i updated it. I was a little late in hitting submit but o well. Its there.

Are you trying to update a Repository Table? If no then this is not the correct way. Have two jobs to do that. One before this present job in question and one after to do the before after updates respectively.

You can have as many different files as you want. Just make sure you cat the correct file for the correct parameter value.

See if this helps

Provide that derivation for column TEMP2 and see if it works.
Change the source as varchar for this column too.

In the transformer stage you have such options. In the constraint of the reject link specify

Have a link coming out of it to a job or wherever you want to store it. Use Activity variable options ($CommandOutput,$ReturnValue) will get you what you want.

You sure its really null and not just an empty string.

Again we are left at the mercy of the guessing monster.

What is Temp2 in your source file. I suspect that it is varchar or character as strtol() is a C function which converts strings to long int. The value is too large for it too handle and hence your error. What is the length in your target?

Load them into a file. Use cat filename.txt to read the contents of that file via Execute Command Stage and pass it to your sequence job. Just covered this over the weekend. Refer herefor details.

Look into Execute Command Stage.

Its all a guessing game untill the OP posts the requirements more clearly.