I posted a very similar solution over a year ago on http://www.mssqltips.comhere. Not accusing you of anything but thought my solution would add some value. ...
This article is excellent. After managing hundreds of packages through monthly updates that require metadata changes to support all types of changes to database schema and package code this...
I have a new solution. This one is Recursive CTE but only builds valid solutions instead of all solutions. It will produce the 3.6 million permutations for a...