DSXchange

So let it be written, so let it be done.

How are you then handling the update of the flat file?

Interesting, nice bit of detective work. Thanks for posting that.

Writing the list of files to a file is certainly not required but if that helps you work out the kinks then by all means do so.

Dear Mr Geek,

Please stop quoting everything all the time and learn to love the Reply to topic link rather than Reply with quote. I'd greatly appreciate it.

I don't know about an "elaborate" explanation but the Start Loop and End Loop stages do exactly what you need - allow activities (jobs, whatever) to be "looped" in a Sequence job and for them to be provided a different set of input values each iteration. And those input values ar...

Something has changed, it would seem. First thing I'd do in your shoes is take the issue to your DBA and see what they think might be going on.

First you need to identify those "special" characters. For that, a hex editor or a hex dump (od -h filename) can be helpful. Or even vi with ":set list" can help sometimes.

raju4u wrote:StringToTimestamp(DateToString(DSLink2.d1,"%yyyy-%mm-%dd"):' 00:00:00.000000',"%yyyy-%mm-%dd %hh:%nn:%ss.6")

Sorry, but why? They don't want to lose the time component and the mask you provided doesn't match the incoming string.

raju4u, please stop always using Reply with quote all the time for no good reason. Use it when it makes sense but normally the Reply to topic link is all you need.

Here for one.

Doesn't really seem like a QualityStage question, does this need to be moved?

What exact version? Are you current on your fixpacks / patches?

Your error message shows a double-quote as the first character of the date string inside the single quotes of the message itself.

Then off we go to your new home...