07-19-2013 11:39 PM
I have created a ETL process in SAS Enterprise Guide. That ETL process takes excel file as an input and further does the cleaning operation. I want to automate this process through a Desktop application built in Visual studio(C#). User will enter a excel file for processing each time he runs the desktop application. Is their any way in which I can run the SAS EG process in Visual Studio which will take the excel file path given as input by the user and further run itself.
I have searched online and found some articles which describes running of SAS EG workflow through C#. However here along with running the EG process I need to give " NEW " excel file as input each time my process of EG would run though C#.
Please help me out if anyone has solution to this problem.
Thanks in advance.