ETL and Data Integration tools - Modern ETL software for everyone

Hi

Is it possible to import jpg’s located in a directory and named with a unique Id with Advanced ETL into a table with a binary column?

Thanks for help.
Kurt

That is easy set data-source type to file system and map data as unusual.

Mike

Hi Mike

That was to easy! …it works great…

Now as you know I have to import data from several branches and the jpg’s for each branch are in a separate directory. Is it possible to read in from several directories and use the directory name to find out from which branch the jpg is?

Thank you for great help.
Kurt

It works only with one directory at the moment.
You can write a bat file to copy files into one directory

Or we can add a check box
Search in subdirectories
It will take 4-5 days

Mike

Hi Mike

It is not urgent. It would be nice If you could put it on your wish list…

Regards
Kurt

Try latest version

3.2.5.2

Added "Search in subdirectories" option to data reader