DSXchange

Welcome Aboard
What version do you have? If you have 7.5.2, go into the readme folder which has a file called "contents". Open that file, click on the link "Whats New". You will see the enhancements there.

You have a few different ways. You can use DSGetJobInfo() function. You can use DSGetLinkInfo(). You can use DSGetLogSummary. Log files are stored in hashed files with the naming convention RT_LOGnnn where nnn is the internal id for a specific job. You can get that from DS_JOBS. Yet another way is t...

If you want default values then set them up at the database level and dont pass that column during insert. The database will populate that column for every inserted record. Usually this is implemented for current timestamp which the database generates on its own if no value is passed. Is that what y...

Well I highly doubt you can quit the execution of just the transformer, what you could do is as soon as there is a direction change, send it down a second link with its property set to 'Abort after 1 row'.

chulett wrote:Give you some candy

Ha Ha Ha, very funny Craig .

Basically do a lookup on natural key to get the primary key which in your case is the surrogate key.
Speaking of natural key, how come it is specified as nullable, you sure the Date column is Nullable

Great, you know what to do next

If you are really on px, you can specify a reject link from the sequential file itself. Dont give any default value for decimal. This way if the length of the data is more than what is defined, it will get rejected.
If you are on server, Whale has given you a pointer on how to reject.

Stick in a "-wait" option so that the execution wont step ahead after the job is reset. Most probably, the second dsjob command is trying to execute a job that is in the process of being reset and hence your error.

You dont need quotes around the variable. Somewhere you are missing a space or something. I thought you said its complaining about the project name?

I think the timestamp format is ok. Dont read it as timestamp. Read it as varchar. Feed it to the C routine and let it take care of the rest. Once you get it into correct format and apply StringToTimestamp() to it, it will be fine. Again, Read it as varchar. The C routine expects a string as its inp...

Thats what ArndW asked you, Is your project really called PROJECTNAME or thats just a variable. If its a variable then you need to prefix it with dollar sign ($PROJECTNAME)

But you wont be able to do that in a single line as the incoming data is not consistent. Index on "V" will have a value even if it gets "Valve" which is also present in your data. Index on "V-" will skip values like V8 or V12. Thats why Ray indicated that this can easily be done in a Basic transform...

Do any of your parameter values contain spaces. If yes then they should be present within quotes in your csv file and you need to add "eval" before the dsjob command.

The message indicates that you are attempting to populate NULL in the key field of a hashed file, which is not allowed and hence the warning.