Hello, I'm developing a process in Data Integration Studio 4.905. The goal is to get a set of transformations, where the first part is a group of loop transformations which can fail and the last transformation should send an email with the status of the failure. The mail should contain a text message in the subject and a table with some data in the mail body. The process doesn't work completely as it supposed to. The mail is being sent, but only the mail subject is available without the data table in the mail body. Once the process finishes and I run only the last transformation, the mail is being sent completely together with the data table. The data table is printed by means of proc print. I can see in the log that in case that all transformations are running together, the proc print doesn't deliver any observation, but once the last transformation runs alone, the observations are being read. Any advice, how can I get the proc print delivering all the observations when all transformations are running? In the meantime, I found a workaround. I’m selecting all values of the relevant column in the data table separated by comma into a macro variable and using this macro variable withing proc odstext for mail creation. It works, but the solution is not very satisfying. Thank in advance for any idea.
... View more