DSXchange

Code tags preserve whitespace.

For Server there are the all powerful "Conv" functions: OConv(OConv(IConv(YourField,"D"),"DMA"),"MCT") DMA will get you the Alpha Month name in CAPS and MCT will then case it as you wanted, just like using the Capitals() transform would. If your date includes ...

Silly. The uninstall is not a guaranteed solution but may work. Only regedit is the certain path and it is just a tool, not something to be feared. Good luck, though.

Have you managed to import the wsdl?

Un-jacked.

What does "working on client machine" mean, that you don't have permission to use regedit? If so, find someone that does and can do it for you, perhaps their help desk personnel. You could try a complete uninstall and reinstall of the client software but using regedit is far quicker and si...

Welcome.

That's not all that uncommon and an exact search for "menu bar" should turn up the solution.

Basically, it means there was a character that it could not convert and the hexidecimal value of that character was "C9", hence the "[xC9]" in the message. Hex C9 is Decimal 201 if you want to go look that up in your source/target charactersets.

Moved to the proper forum, removed cell phone number and request to "setup a call". Discussions happen here, not over the phone. FYI, I deleted the duplicate post made under another name as well.

Why not script this if all this is is a validation step? If the validation fails, don't run the processing job. Between a count of the total records in the file and a check to see how many records start with "H" and "T", you should be able to whip something up. Use a Sequence job...

You probably need more disk space rather than higher settings, have you tried monitoring that while the job runs?

Have your DBA check the plan for the query, sounds like there's an index being used in Dev with Prod doing a full table scan.

What "some option" did you try and what didn't work about it?

"Hi Ray"?

I would probably end up scripting this - run the script 'eternally' and when it detects the file, launch the job, make sure all goes well and then go back to monitoring.