DSXchange

Won't this part be problematic?
Doing math on a string? A Server job would have no issue with it but I imagine a Parallel job would complain just a bit.

Just like I said.

So "use" it as an Integer and then convert it to a string before you concatenate it to your other varchar.

trammohan wrote:DSLink8.val[ Len(Trim(DSLink8.val )),1]

Again, I think people are putting too much faith in the accuracy of the example posted. They want the last "value" / field, not the last character.

ntr wrote:can you post what Exact input and what exact output do you want

They did, the first post shows that. The second example shows what they got instead of what they need when taking the aggregation route.

You're right, didn't notice that the last group was the same as the first group so that aggregation while correct is not what you want. For your stage variables, 0 means the record is the first record of a new group, the 1 means it is another record in the same/current group. If you have the 8.5+ ve...

For the sample data you posted, the aggregation approach you mentioned is what I was going to suggest and should work fine... again, for the example you chose to post. Can you show us the input and output data that shows the "overlap"?

Show us your problem child.

OK, I'll start... what have you tried? Anything involving an Aggregator perhaps?

There must be more information available. Are there any other messages? What about in the jobs that the sequence runs, are they failing?

OK... there are a crap-ton of results returned if you google for "the handle is invalid" but it might help if they were narrowed down by the specific O/S involved. Wasn't sure if you tried that or not. A lot of the issues reported seem to be around permissions...

Now, as to your question, how familiar are you with the concept of stage variables? In my mind, the way to get the first X records from any group is to use stage variables to do group detection. Since they are evaulated from top to bottom, you can order them such that you can compare a current value...

Thank you for your reply and the explanation... and (hopefully) for taking my suggestions to heart. Actually i want to shorten the question for readability purpose. Please don't, we like to read! This generally falls into the Very Bad Idea category. One of the biggest problems we have here is when p...

I don't see anything "official" other than PayPal... out of curiousity, what kind of issues are you having with it? Or is it that you don't want to use it? I'd suggest trying to contact the Membership Director and explaining your situation, if you haven't done so already. membership.direct...

vamsi.4a6 wrote:How to create Dos file.

Set the Record Delimiter String property to "DOS".

What Windows is this, Server 2003?