DSXchange

Can you get it working by having separate stages for the three queries?

You can try ereplace.
You can try Iconv, Oconv. What else you want.

Don't ask me why this has fixed it but it has! This happened because may parameter get binded with the executables :? And if you execute them directly (without a fresh compile), instead of taking the current value in place of $PROJDEF, they take whatever was already binded :? :?: Experts please cle...

Which is your database?

I tried with Sql Server with the value I got

1.0000000000000001E-19

in the table.

The datatype of the column is float.

What I am trying to do is have our jobs run without any warnings.

My question was more on the particular job that is having issue,
What is it having (the design)?
Are you having any thing parameterized, is there any chance that you are having a parameter value difference (between the servers)?

You can get it done through a routine (remover the spaces and hyphens in the routine) prior to running the server job and can then pass the parameter to the server job.

Do a reset through the director and see if it gives any thing extra.

What are you trying to do?

At what place you are using it ?(very important)

You should be using it within a routine which can be called through after job subroutine. This will make sure that your job has finished and the counts on the link are the final.

You would need to write your own program for parsing the log file (if you want to do it outside ds). But doning it that way is time consuming and may not be accurate at times. You can use the DSGetLinkInfo function which can be used from within the job or outside the job (may be a separate routine) ...

If i move the job from Dev to PROD wont this be affected?

Surely it will, if the schemas are different.
Use Job parameters for such cases.

I guess DSGuru meant:
Just a typo

How are you guessing that the error is something to do with these columns only?
Is there any date column also within the target table?
Can that be causing problem?
What datatype you have specified for date fields?
What is your target database?

Hope I will be helped in fixing the below error. That's obvious, no need to mention. :wink: The input column is a decimal and I doing some calculations on a specific column and trying to load into the target table. What sort of calculation is this, is it involving any other column also, what is the...

Reindexing might help, but is the last resort.
Did you try that? Is it on a production or a developement server.
Is there any chance that your dsx file is only having program sources and the executables, no job design.
Can you rename/delete a corrupted job? Then import it from the backup.

Ok don't think that is the hurdle.
Did you tried the derivation that i suggested? Are you getting the suffixed string also.