DSXchange

Not using that stage. You could, however, write your own script/wrapper to send the email in any fashion that you like. Check the DSSendMailTester routine as well for ideas.

If it's not SQL then that's not the place to be running it. Sounds like you need to run it before job rather than before sql.

Open the job, open each transformer and count. You did say "a" job, after all.

A search for USERSTATUS or DSSetUserStatus will give you another approach if command line sql queries are out of your comfort zone.

It's not. Please post the complete, unedited error messages from the log.

Sounds like it's time to mark the post as Resolved using the button at the top of the screen!

Post your job design.

Dashes, not slashes.

Then use StringToTimestamp() with a mask the matches your input format. What you show as 'required output' isn't really true if you are targeting a Timestamp but might be if you were a string. Or perhaps "timestamp_from_string", depends on the stage you are doing this in. I believe that's ...

1) What does show up in the Director log? Anything? Make any difference if you run from the Director?

2) It's not or we wouldn't be having this conversation, you'd be wondering why your dang project was locked and no-one could even log in.

Bottom line is you use the heart and soul of the Server product, a hashed file as a reference lookup. Build a list of your existing keys in a hashed file and then use it to decide insert (miss) versus update (hit). You can also refine update to mean 'only if changed' by including fields to compare (...

Once you get your membership, come back and check out a couple of other posts on the subject. The long and the short of it, Ken Bland style.

Doesn't sound like there's any reason to 'code all the transformations' again if you've already done that when loading to your big source table, unless you need additional transformations specific to the Oracle target. You've confirmed you have a single source but not if you have a single target. I ...

No need to challenge anyone, people will help when and if they can.

Hmmm, sorry... can't help you with that one.