DSXchange

Craig, I did not intend to be rude and am not ignorant of the poster profile mechanism. But there are examples given in the tutorial and search is available. Also Ray had answered similar post before. The questions raised indicated more of requirement of reading through the docs rather than posting ...

What if you re-try?

Make the job "sleep" for that duration.

Is it possible to describe what you want to achieve in full rather that in parts.

I assume Ray has answered few of your questions. Have you worked on them?

Can you provide a glimpse of your knowledge with the product so that others can guide you appropriately.

What do you mean by "not giving correct data"?

Unless you share the results, it is not even possible to guess what is happening differently.

I assume you have already done this....but still worth confirmation 1.) Login to the database via its own GUI and view the data to check it is more than 6 chars length 2.) Check which database the ODBC points to 3.) Check whether the source is a view and whether any function (like substring) is bein...

currKey = (if div = "G" then key else currKey)

Note - this is left partial assuming you will always have a G for each ID.

Remove the max length from A and add the check in a transformer in the flow.

Remove the max length from A and add the check in a transformer in the flow.

Why don't you create separate stage variables ?

How do you decide when to write them to output?

Being v8, multiple users appear to be mapped to same OS user.

I think Ray has answered to a very similar question from you. Did you try working based on his response?

Try a Trim(Variable[from,len]) rather than Trim(Variable)[from,len].

What does 'one year from now' mean in simple english?
...especially for '29-02-2008'?