In order to follow the steps as indicated, you will need a data flow task that connects to a data source, and destinations to which the separated flows can be directed into, which includes a destination for the default flow that does not meet the criteria established for data splitting. You will also need to add and configure an in-memory ADO recordset destination, the Recordset Destination component to visualize the data.
The following are the major steps of this exercise:
Create a BI Project and add a Data Flow Task. Add and configure the DataReader Source to pull data from the Local SQL Server.
Add a Conditional Split Transformation.
Establish a path to Connect DataReader Source ...