Cool sampling trick with Integration Services

One thing that has always been difficult with some of our advanced data mining features in SQL Server is handling nested tables.  For example - how do you split or reduce data sets when you have multiple tables that have to stay in sync?  How, you ask?  Well we posted a neat tip at that shows exactly how to do that.  A sneak preview is that it looks like this:



Visit for instructions and the package including sample data!

Skip to main content