Hi all,
I am struggling with the problem as below.
"A folder contains many source files (may be excel or text file). Need to create a solution which gets the information from SQL server table about
which particular file/files will get loaded in target SQL server table".
Not sure how to pick files whose names match with the names listed in an SQL server table. And then load each file into another SQL table.
I only know how to load multiple files from a folder to an destination SQL server table.