DSXchange

If there's no "." the Field() function will return the entire string.

Not necessarily. Implicit conversions work only when there can be no ambiguity. For example there is no ambiguity in integer to string, because every integer can be represented as a string. The reverse is not true, however, because not every string can be represented as an integer. Therefore an expl...

I suspect you're using Integer as the data type and getting overflow. A date in the future ought not to generate a negative timet. Try using dfloat as the data type.

Nothing more? There's usually a summary at the end of what occurred. Is there a "bad" file in the same location? Are you certain you haven't posted the CTL file?

Hey, come on. That is totally not the original question. Have you wasted our time here? It's a new question: please begin a new thread for it.

Why not just insert a row that does not mention the identity column? This will force the database to create the next value in that column. You don't really need to retrieve the value.

With EtlStats you get all source code, so you should be able to modify it to do what to ask. I don't believe treewalking a nested hierarchy of job sequences is possible out of the box, but it ought not to be that difficult to do. But you will need to make decisions about which run of a job that migh...

There is no certification for server edition, and currently none planned.

Never, ever kill a DataStage process with End Task. You can use Cleanup Resources from Director or the DS.TOOLS menu on the server. Configure the deadlock daemon (dsdlockd) to run; this will automatically clean up locks held by defunct processes. You can also (as administrator) invoke dsdlockd -p (i...

NullToValue() is a function for the Transformer stage. It is an error in the Parallel Job Developers Guide that this function is for the Modify stage. The correct function is handle_null() which you can read about in the Orchestrate Operators manual. This can be had for the asking (ask for "OEM...

All the functions should be in the Parallel Job Developers Guide chapter concerning the Modify stage. There are some errors in this chapter but none, as far as I am aware, relating to the type conversion functions. A more accurate document is the Orchestrate Operators guide, which can be had for the...

balu_infotech wrote:source to target mapping is propere .this job is runing on daily bases.yesterday job got aborted ,perviouly it is working fine

So what has changed? Tip: "nothing" is not the correct answer.

As I already advised, check the data.

How is this new question different from this question?

Do you have any idea how annoying being asked the same question multiple times is?

In the Then clause of the WriteSeq statement in your code.

You have one loop but two Next statements. That's why the compiler did not expect the second Next statement. Prefer to code something like the following. OpenedOK = @FALSE OpenSeq ... To var1 Then OpenedOK = @TRUE WeofSeq var1 ; * truncate file if it exists End Else OpenedOK = (Status() = 0) End If ...