Skip to main content
Question

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

  • April 2, 2025
  • 2 replies
  • 41 views

sunita22
Contributor
Forum|alt.badge.img+2

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

2 replies

liamfez
Influencer
Forum|alt.badge.img+43
  • Influencer
  • April 2, 2025

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.


takashi
Celebrity
  • April 3, 2025

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