Hi Team, I have a requirement for automation process. Need to read around 6 excel\csv files from particular path(local or FTP) and load the data in single table. based on that table need to create a report. this is daily process. Every day morning some one place the excel\csv in path.
below are details process flow. Step 1: Read the Excel\CSV files from particular path. Step 2: Filter the data based on conditions. Step 3: Join the filtered data to another table and load the final data in server. Step 4: Create a excel report based on above table. (Report can be created using Developer studio) Step 5: Send the Excel output to group of user thru Email. ( we can schedule report in report caster)
Need to automate first 3 steps.(like MS SSIS package) How to achieve this process using WF\Data Migrator.
Please help me on this.This message has been edited. Last edited by: Maran,