How to use Multi URL/Path Mode in SSIS JSON Source


This article guides you through retrieving information efficiently when you have multiple URLs or paths with similar data structures. By using the UNION all URLs with a single dataset approach, you can return responses from all URLs in one step.



  1. Add a Data Flow task to your SSIS package.

  2. Inside the Data Flow, add a Source component. In this case, we will use the JSON source component.

  3. Enable the option Enable Multi URL/Path Mode.

  4. In the first example, we will use two different file paths separated by a double colon (::). For instance:
    C:\Users\DELL\OneDrive - ZappySys\Escritorio\test\JSONs\books1.json::C:\Users\DELL\OneDrive - ZappySys\Escritorio\test\database\books2.json
    Here is the result:

  5. In the second example, we will use three different URLs separated by a double colon (::). For example:
    Here is the result:

  6. Test the examples and save the configuration by clicking OK.


Following these steps, you can read multiple URLs/paths with only one component with a similar structure. For assistance or inquiries, contact our support team via chat on our website or through email at


For more detailed information, refer to our JSON source article.