DSXchange

You have to provide the fully qualified path of the script. Possibly even

Hashed files are not present in px jobs.

Welcome Aboard
Have you installed the C++ compiler?

You can do a select and pass the two values as parameters to UtilityRunJob() inside the transformer. This way for each record, the job will be fired.

It is certainly possible but you need to provide all the connection information, table names etc etc.

I just gave a visual view of Ken's suggestion

Yes.

In server it would have worked. But in px you need explicit conversions. You can use either the modify stage or the transformer stage and do the conversion. You can use StringToTimestamp() and StringToDecimal() in transformer. I think their modify stage brothers are timestamp_from_string and decimal...

Ok, now thats criticial piece of information. How exactly did you change the varchars to timestamp and decimal? Did you use an appropriate function for the conversion?

This is a perfectly normal 'warning' that you get whenever you call either of the sdk KeyMgt 'GetNextValue' routines for the first time in a Project. Hmm...I didnt know that. I hardly use SDKSequences and hence my ignorance. Ignore my previous reply speedsterrules. Run the job again and see if you ...

Ok, if its pipe delimited then specify "" as Null Field Value under 'Nullable' properties.

@NULL is not present in a px transformer. Use SetNull().

Reset the job and see if any message with heading "From previous run..." pops up. If it does, post it here. Also, where are you creating "D_SDKSequences" inside your job?

You need to edit the row and specify default value if null is encountered. Also, it is a fixed width file right? So for "loss_date", you need to provide 19 spaces, for "equipment_non_return_fee" 20 spaces and so on. I think thats the way to go about it.