Unable to Add Multiple Inputs to Script Component in SSIS

Question

Hello SSIS experts,

I'm encountering an issue with a Script Component in my SSIS project. Here's the situation:

I'm trying to create a Script Component of type Transformation that accepts two input sources. However, I'm facing a problem in the Script Transformation Editor where I'm unable to add a second input.

Specifically:

1. I've added a Script Component (Transformation) to my Data Flow.
2. I've opened the Script Transformation Editor.
3. In the editor, I'm unable to find an option to "Add Input" or create a second input source.

My question is: How can I configure the Script Component to accept multiple inputs? Is there a specific setting or approach I'm missing?

Additional details:

• SQL Server version: [2019]
• Visual Studio version: [Professional 2022 (64-bit) - Current

Version 17.10.1]

I've tried looking for an "Add Input" option or similar functionality, but I haven't been successful. Any guidance on how to properly set up a Script Component with multiple inputs would be greatly appreciated.

Answer 1

Hi @Hossein Farahbakhsh,

You may put a Union All component before your script component.

The Union All transformation combines multiple inputs into one output. For example, the outputs from five different Flat File sources can be inputs to the Union All transformation and combined into one output.

Union All Transformation

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.