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 ...

OK, I am not sure how to describe this. I guess I want to flatten a table into two columns... so basically pivot. Though I can't aggregate it like I could if it was quarter 1 sales, etc... <BR><BR>I'm ...