Read multiple JSON files from a folder

Apr 20, 2016 at 1:52 PM
Hello,

I have multiple JSON files that I would like to load.
Is there a way for the Source component to read all JSON files that are stored in a local folder?

Thanks
Coordinator
Apr 27, 2016 at 3:07 PM
Hi,

there is no way of telling the component to bulk import all the json files from a directory, however there is an alternative possibility.
You might use the For-Each loop editor alongside a very simple C# / VB.NET script, so that you map the filename into a variable. Take a look at here: http://stackoverflow.com/questions/6229597/ssis-get-any-flat-file-source-from-folder-and-cache-the-name-as-a-super-global.
Once you manage to do that, tell JSONSource component to read the input file from the same variable that you are populating.

I hope that helps,

Alberto.
Marked as answer by webking on 4/27/2016 at 8:07 AM