The FileList driver is designed to retrieve a listing of files on a specified path in the local filesystem.
Connection String Parameters:
There are no parameters to set in the connection string.
Query Parameters:
The filelist can be retrieved by a SELECT command in the following form:
SELECT * FROM [path_to_folder] WHERE filename='filemask' AND directory='current|full'
Current         List all files in the specified folder
Full                 List all files in the specified folder and recurse subdirectories
Example:
LOAD ASSEMBLY 'TARGIT.FileList.dll'
DATASOURCE [FileList] = DOTNET CONNECTION 'TARGIT.FileList.FileListConnection' ''
IMPORT [csvFileList] = [FileList].{SELECT * FROM [D:\DemoData] WHERE filename='.csv' *AND directory='full'}

  • No labels