Data Services and Flat Files

[Former Member]

Hello all,

Under Data Services, we try to build a generic function which accept several parameters and send "standard" email with attached files.

For that, we need to create a flat file containing the body of the message and a flat file having parameters (the attached file will be generated by DF).

Is it possible to create a flat file under a Data Services' function, the mail sending will be take in charge by an external application (ie blat). Is it possible to execute a Dataflow under a function?

In fact, we "just" want to call a function to automatically send an email including error message (code + log) with attached file. Do you know if it's possible or is exist workaround ?

Best regards

Laurent

[Former Member]

Hello Laurent,

Place the try block at the beggining of the job.

Try->dataflow->script->catch

Inside catch, after selecting all the exceptions, in the work area in catch, place the script/Exec function  to send a mail.

In order to send attachments via E mail You can try This Solution.

You can also use 3rd Party Tools such as BLAT and call the executable file Containing BLAT script with EXEC() Function in Catch block.

Let me know if it helps your cause.

[Former Member]

Hello Sandeep,

Thanks for your response, we choose the third party tool: blat, we embedded the execution of blat and the message building into a personnalize function.

regards