DSXchange

Welcome.

"no longer works" means exactly what? What does or doesn't happen, what errors do you get?

Good.

You seem to be out on the bleeding edge of the product, not sure how much experience there is with 9.1 out in the wild but perhaps someone here will have a suggestion.

sendmkpk wrote:Moderator@ Plz move it to EE forum

No, this is a perfectly "general" question.

Your user in the SIT environment doesn't have the permissions it needs to work there. Get what you need to write to your temporary config file location.

FYI - Writing in all capitals is considered SHOUTING on the internet in general and here as well. Please don't shout.

AndreasK wrote:Has anyone an idea where i can get more informations or how i can solve the problem?

One place to start would be with your official support provider.

One thought - use a sub-query into the audit table. Can you do something along the lines of: select * from xyz where tran_date > (select last_run_date from audit_table where ???) Do you have a way to join to the proper audit record for the job in question? The downside of that is you wouldn't have a...

<moved to the proper forum>

You'll be fine, everything will work "as is". After the migration you'll have the option to start using parameter sets if you so choose.

That makes it something that can be done rather easily in a Sequence job. An Execute Command stage can get the filename and the result can go to the Job Activity stage's filename parameter.

That's not any kind of "fixed width" file, that's a simple tab delimited file and it should parse fine if you change the stage accordingly.

Clarify something for us - is the 'filename' a standalone parameter to be passed to the job or is it part of a parameter set with a values file that needs to be updated?

Silly requirement. Use the best tool for the job. Perhaps you can do this in steps. Use Convert() to remove all of the digits and punctuation then check the size of the result. If it is zero then it was 'only numbers' and is invalid. Then from that result upcase it and use Convert() to remove A-Z an...

Jaydev wrote:I am new to routines as well as bat scripts.

That will complicate your effort but this should be a great learning experience.

A script or routine can be used to detect the current name of the file and then you can either update your values file or pass it as a parameter to the processing job.

FYI - There is also a syntax file available for UltraEdit for anyone using that.