SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Sending emails using SAS DIS transformations

Reply
Contributor
Posts: 37

Sending emails using SAS DIS transformations

[ Edited ]

Hi all,

 

I know that it is possible to generate an email through the "Publish to Email" Transformation in SAS DIS. However, we can only use it if our source is a data set, right? 

 

Is there any other way to generate an email using SAS DIS transformations (excluding the User written code where I could use the FILENAME EMAIL statement for example)?

 

 

Thanks,

 

May15

Super User
Posts: 5,829

Re: Sending emails using SAS DIS transformations

It's SAS so options are as usual many.
Tell us what you want to do, and then hopefully we can guide you to a decent solution.
Data never sleeps
Contributor
Posts: 37

Re: Sending emails using SAS DIS transformations

Hi LinusH,

 

For example, I'd like to send an email that contains a message that is previously saved in a .txt file. I know how to do that using the FILENAME EMAIL statement in User Written Code as I said above. I just wanted to know if there is a specific transformation (not including User Written Code) through which we can do something like that. It is just to get more envolved with the transformations provided by DIS and not only with User Written Code. I think the "Publish to email" transformation only works if the source is a data set.

 

 

Hope it helps.

 

 

Thanks,

 

May15

Super User
Posts: 5,829

Re: Sending emails using SAS DIS transformations

This is still the how, not the why.
Remember, DI Studio is for generating code for data flow - ETL. Usually sensing emails is not part if that flow, rather as an utility to send notice to administrators, data stewards and power users. And that can be handled in post processing of transformations or jobs.
Data never sleeps
Ask a Question
Discussion stats
  • 3 replies
  • 193 views
  • 0 likes
  • 2 in conversation