Skip to main content
Question

How to give file path to load multiple CSV file to SQL server?


sunita22
Contributor
Forum|alt.badge.img+2

I want to give file path to load multiple CSV file to SQL server, How to give file path to reader to select multiple CSV file?  

3 replies

joepk
Influencer
Forum|alt.badge.img+20
  • Influencer
  • March 14, 2024

You can use a FeatureReader set to Directory and File Pathnames to read all the filenames within a path, then use the resulting features in another FeatureReader (Dataset = @Value(path_unix) ) to read the CSVs.

 


sunita22
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • March 14, 2024

I have 2024 version of FME, where I can see FeatureReader ?

 


joepk
Influencer
Forum|alt.badge.img+20
  • Influencer
  • March 14, 2024

The FeatureReader is a Transformer, you can add transformers by typing the name in your canvas, or by searching for it in the Transformer Gallery in the down left corner.

In order to initiate the FeatureReader, you need a single feature, I create one using the Creator:

 

I am using FME 2021, but 2024 should work roughly the same.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings