data source CSV file each day populated with date stamp, my requirement need to load CSV each day to SQL server

I am not sure where the question is, but if you want an attribute added to data with the current time stamp then the DateTimeStamper will do that.

Hi ​@sunita22 ,

I'm not sure I understand your requirement correctly, but if the csv table has a column which holds a date value (e.g. "20250401", "20250402", ...) and you need is to create destination tables for each date (table name contains the date value), I think you can apply "Feature Type Fanout" to to that.

See here to learn more about Feature Type Fanout.

https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Form/Workbench/fanout_about.htm#FeatureTypeFanout