How to use the Enable Multi URL/Path Mode in SSIS

SSIS PowerPack
1

Introduction

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

Prerequisites

Steps

  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 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:

    Example 1
    Example 1828×735 100 KB

  5. In the second example, we will use three different URLs separated by a double colon (::). For example: https://jsonplaceholder.typicode.com/todos/4::https://jsonplaceholder.typicode.com/todos/1::https://jsonplaceholder.typicode.com/todos/2
    Here is the result:

    Example 2
    Example 2828×735 52.1 KB

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

Conclusion

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 support@zappysys.com.

Reference

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