DSXchange

True. My primary goal here was to correct the mis-use of the substring operator. As noted, they're not needed at all to accomplish the goal here, however if one is going to use them they need to be used correctly.

I? Do you post under two different userids?

Ray asked because you posted in the Parallel specific forum... off we go to Server land.

Therefore, the syntax is incorrect. :D

sravan555g wrote:Is there anyway to configure the target or source stage to hold and retry after few minutes if it cannot connect and continue the job from that point after successful connection?

No, I'm afraid not.

Why don't we start with you showing us the syntax you are using?

Once more with feeling - you have (as one example) "in.column[6,7]" where you are telling it to substring from position 6 to position 7. That is not the correct syntax. You need to tell it to start in position 6 and substring out 2 characters: "in.column[6,2]" Once they are all c...

I already did tell you how to achieve it - correct your syntax.

The substring operators do not work from start position to end position as you've coded it but rather they use start position and length.

mac4rfree85 wrote:When we used decimal, decimal values are not getting inserted. Hence only we have used float.

I too would be curious what this means.

OK, how about posting the complete unedited error message?

Which part is still unclear?

Of course there is!

1. Get a Premium account so you can read Ray's reply in its entirety.
2. Stop using Float as a data type.

Is that with or without a stage after the XML Output stage? If you want to pursue the validation issue, please start a new topic so it doesn't get mixed up with all this 'multiple files' talk and we'll see if we can figure it out. Still hoping Ernie might pop by and give us his thoughts on the origi...

What did you install between the last time it worked and when it stopped? Anything? Many times things like this happen when one version of a dll gets replaced by an older/newer version, the newly installed software works fine but anything else dependant on the clobbered version... not so much.