DSXchange

I'll wager that's just a typo in the header record from hand-typing the source data example.

Then something else is incorrect and you'll need to track it down: you are connecting to the wrong 'instance' or your password or userid are incorrect.

And in case anyone is interested, there is a new FAQ available on this very subject thanks to Franklin.

Developer9,

Please stop hijacking multiple posts with your issue. I'm locking this three year old post and you can continue the conversation in the appropropriate place: the post you created:

viewtopic.php?t=143583

You cannot include parameters in the SQL File, that's one major drawback to that approach. You will need to build the file with the actual parameter value included in it rather than referenced in it.

You need to decide where to round a fractional year up or down and then adjust the code accordingly.

Which is why I said "no" was the short answer. They allegedly exist but are not publically available and as Ray noted, only available if you pay IBM to convert your jobs for you. Even so, their conversion software is only X% successul with X varying wildly, so there is always a final wetwa...

No way to know without seeing the actual code. Perhaps someone 'fixed' it in the other environment...

That's not usually an option, so you typically either match that format or use TO_DATE() in your DML so that the default format is not an issue.

Rodre - what was your resolution? I don't see an issue with anything you posted, was it just a... select issue?

I don't recall one that doesn't, it was just a matter of figuring out how it wanted them to look.

I would guess they are not actually getting input correctly in the Job Activity stage. How did you set this up - did you create job parameters in the Sequence itself and then assign those parameters to the parameters in the stage or did you 'hard code' them there? Did you enter anything by hand in t...

That's not the problem, an Oracle DATE field is actually a timestamp. Seems to me your time portion is not being successfully added to the date. What is the actual output of your OConv function?

Really? Isn't that the whole point of that environment variable to pad short character fields? So reading a comma delimited file where the source data is shorter than the CHAR size noted, it should reject the record rather than simply pad it out to full size?

An implicit conversion is one where the engine itself (rather than 'you' in the job) are performing the conversion. This as opposed to an explicit one. As noted, you are moving data from an unbound string to a bound one and thus it is warning you that it just might possibly truncate the data. You co...

Short answer is there is no conversion tool. As to the how, you make sure you understand what the Server job is doing and rebuild it as an equivalent Parallel job. Now... I hope you're not at one of those shops who have just upgraded to the Enterprise Edition and suddenly think you have convert ever...