You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a source system into a data warehouse hosted on SQL Azure. One of the columns in the data source…

Source Assistant is a design-time helper for adding source adapters to a data flow; it does not participate in row-level transformation or routing logic.

The Audit transformation appends system-level metadata columns (such as package name or machine name) to each row and does not provide the ability to split or route rows to separate outputs.

Destination Assistant is a design-time helper for adding destination adapters to a data flow; it does not inspect row content or route rows between processing paths.

The Script Component can be added to a data flow as a transformation and configured with multiple synchronous or asynchronous outputs, allowing custom C# or VB.NET code to inspect each row's ProductCode and direct it to the appropriate output buffer. This provides full programmatic control over row routing when the built-in Conditional Split is not listed or when more complex logic is required. Each output can then feed a separate downstream processing path in the data flow.