http://blogs.msdn.com/philoj/archive/2007/11/10/transposing-rows-and-columns-in-sql-server-integration-services.aspxOkay, this was a rough one. The challenge was that a customer had Excel spreadsheets where we needed to transpose the rows and columns. In other words, the spreadsheet looked like this: But we needed the records to list Program values by date, like this:en-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/philoj/archive/2007/11/10/transposing-rows-and-columns-in-sql-server-integration-services.aspx#9788063Fri, 19 Jun 2009 17:26:05 GMT91d46819-8472-40ad-a661-2c78acb4018c:9788063 Philo s WebLog Transposing rows and columns in SQL Server Integration | debt consolidator<p>PingBack from <a rel="nofollow" target="_new" href="http://mydebtconsolidator.info/story.php?id=17014">http://mydebtconsolidator.info/story.php?id=17014</a></p>