DSXchange

I think you need to get in touch with Ascential support. There are other connectors available. Some unix based apps too. But never got a chance to work with it. Your best bet, try getting in touch with support.

parag.s.27 wrote:Yes you can do it in a single job......
just create 3 files with header, details and footer....

and then use Link collector having proper link execution order...

I dont think that would work, unless the "details" has a single record.

If you can send an email to your mobile from your favourite mailing giants, then you definately can send it via DSSendMail() or the notification activity in a job sequence.

Naa, i dont think youve missed anything. Still needs to get here. ToolXchange would really be nice

I would suggest, if you have time, to develop a basic code for it and do this kind of manipulation in a basic transformer. If you actually google "convert numbers to words", you will find many programs written in different languages to assist you get the data structures. And if you can come up with ...

Jules agrees with Craig.

Kim. You rule. Thank you so much for sharing these jewels with us.

Pay attention to what Ray stated. If a job "finishes with warning" it actually did finish. You cannot abort that job from the sequence. It can stop from triggering the next job but not abort that particular job. For that you need to handle that inside the job itself, or maybe limit the warning to 1.

Yes it will be. Just pulling your leg sud

Hijacking is not permitted
Ops, that was a little harsh, just pulling your leg
Try browsing for the file server from within the sequential file stage. If the server is visible, then you can.

You're right... it's over on ADN. Knew it looked familiar. Turns out your syntax isn't quite right, even when fully pathing the files - you can only fully path the first file. If you supply a full path for the second argument you get the error you posted. Try: rename E:\file1.csv file2.csv and you ...

Is it just for status 2 that you need to stop the processing or for any status other than 1. If thats the case, then provide "Finished OK" expression in the trigger for the next job and provide another link coming out of the job activity that has expression "otherwise". Let that go to a sequencer wi...

or you can just use macro

if no function is performed on user defined SQL, why use it. Simple just use the generated sql and then see the difference in performance.

In the next job, you can do it in the before job subroutine. Also, i would advise not to delete the file untill the end of the entire process. You might be needing to look at the file if something goes wrong. Basically for debugging purposes. If that is not an issue, then i would go with Kris's sugg...