DSXchange

How do you expect people to be able to help you when you post examples of how to do something? We are old and crusty and don't need a dang example - we need to know what in the heck you are actually doing to be able to help properly. Sorry but this is one of my pet peeves.

Or that.

They look the same but are they actually the same value? I ask because of this from your posted code: * Setting parameters of job ErrCode = DSSetParam(hJob1, "Parm1", "Value1 ") Note the extra space after Value1 which would not be obvious in the log message. Of course, this could...

Now, the values of parameters I passed are the same in both executions (from JobA and directly), but the result are differents Did you verify this by checking the "job starting" log message in both runs of JobB or is this just something you "know"? It would seem you don't do any...

manoj_23sakthi wrote:Hi
sorry for this..
I am not able to post this in new post.

Why not? All you need to do is click on Post new topic anywhere in the appropriate forum to start a new post.

Split out for you.

Do an exact search here for "the record is too big to fit in a block".

IsValidDate()

Doesn't quite relate to your subject, though.

So "JobA" is a Sequence job and "JobB is a Server job"? And you've confirmed that parameters are being passed correctly from the Sequence?

As noted, it comes back in a dynamic array so you can use array notation to ensure you only pass the first record to the parameter: Max_param=Execute_Command_0.$CommandOutput<1> It should like that more better. As for your red text question, simplest way to be sure is to try it and see what gets log...

They're all in the post. Try googling what an ORA-01114 means.

Do an exact search here for "double convert". You will need to know what "special characters" are allowable to perform this validation.

You don't have to have your database on the ETL server to use Automatic loading from what I recall. And you need to take your error to your DBA - you may have disk errors / corrupted blocks and the writes are failing or it could be offline / unmounted or settings may need to be increased. Involve yo...

Craig, Ray... six of one, two dozen of another.

Just wondering how to use stage variables to track the records with a number and add one after that for ones that do not? I would check for a null v. non-null sequence number. Non-null, store it. Once you hit the nulls, add 1 to the previously stored value. And as noted twice now, do this in sequen...

Of course I can see that, I'm just trying to say that the 'serial number' part of your post looks very straight forward to me. You should be able to use stage variables to track the records with a number and then add one after that for the ones that do not. As for the 'serial' part, I would look at ...