SSIS is a pretty useful tool for designing ETL processes, but one of the transformations I was disappointed with in 2005 was the lookup. It was a little better than the lookup functionality in DTS, ...
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 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback