Tips for using SQL Server 2017 Integration Services (Part 1) If you need to distribute data rows to multiple downstream data flow components, you can use the Conditional Split and Multicast transformation. This transformation was first added in SQL Server 2005 Integration Services and make easy for developers to build packages with complex data flow without writing any code. Try…