You can work with pivoted data in SSIS package, as if it were just another data set. But it requires the Pivot transformation and jumping a few hoops to get there. The Pivot transformation is one of ...
Anthony Stevens (pictured below) is the founder and CEO of Digital Asset Ventures and co-author of Chasing Digital: A Playbook for the New Economy. In this guest post, Steven’s talks the value of ...
The Pivot transformation is one of the most useful transformations in SSIS, and also the biggest pain to configure. It comes with one editor, the Advanced Editor, so no pretty GUI here. Let's walk ...