SSIS JSON / XML / Excel / CSV Source / File System Task - Use wildcard in the path

Introduction

Some components like the Advanced File System Task, JSON source, XML source, Excel source and more can use wildcards in the path. The same techniques can be used in ODBC JSON Driver , XML, CSV,  Amazon, Azure, SFTP Drivers part of ODBC PowerPack Product.

Examples

We have some examples you can use:

For all types of files

.../path/*.* 

For a specific type

.../path/*.json

For a specific filename 

.../path/date*.json

 

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to [e-mail]

https://zappysys.com/support/