DSXchange

You can get all link rows counts after the job completes to populate your audit table and that would include any zero counts as well. Trying to do all that "in job" isn't really possible if you have no input.

Start by telling us what "does not work" with the CFF stage because that is precisely what it is for.

What database?

If your integrity issue is because you are writing records to the hashed file as you insert them into the target database and they don't roll back when your job crashes and the inserts are gone, there are a couple of options you might look into. One is to enable the 'backup' option in the hashed fil...

If all you ever do is inserts, then the "performance" will be identical between the two options. The key question would be what do you want to happen if the insert fails? In your original scenario, it fails the job. With the switch to an "upsert" it will attempt to perform an upd...

Off to your own thread...

So, you didn't actually change the values you are passing in - did you change the parameter type? Please post the full, unedited error message. Also, remove the quotes.

You must pass in a Date in YYYY-MM-DD format which is why '201207' is invalid. Change the parameter to a String if that is truly what you need to pass to the job.

Technically, the command line is where you run the orchadmin (and many other) functions. This might help if the concept is new to you.

Ganesh - either stick with your current installation thread or start a new one for errors, but please do not do both. I removed the duplicate posts in the other thread.

Sorry, by "field" I meant the Field() function which makes pulling sections out of a "delimited string" quite simple. So, something like: Field(lnk_TestDataRead.EMAIL_ID,"@",2,99) Would get every "field" starting with the second one in the column, considering ...

Try to get the string after @ in a Stage Variable and then try to find period. Just curious what you (jonesv) are using for this - field, I assume. Also curious how far you need to take the checking - what if is doesn't have an "@" in it? Or has more than one? Doing these kind of validati...

You'll get a lot closer. :wink: FYI, the dsjob syntax is fully documented in the Programmer's Guide pdf in the Command Line Interface chapter. For example: -param specifies a parameter value to pass to the job. The value is in the format name=value, where name is the parameter name, and value is the...

No. My post clearly shows it must be the parameter name, an equal sign and then the parameter value. The value should be whatever is appropriate for the parameter.

In other words, incorrect. Please (re)read my post.