Matt Miller (#4) (3/3/2015)
By the way - there are several examples already documented. This one's a fairly solid example (describing a similar process)http://www.mssqltips.com/sqlservertip/1761/how-to-use-the-unpivot-data-flow-transform-in-sql-server-integration-services-ssis/[/url]
That said - you're still right - it wouild require some form of a script task to pull out the column headers and compose them into dates. In this case the script would likely be embedded within the data flow in SSIS.
Excellent article. Thanks for the link, Matt.
If only spreadsheet users wrote such nice clean spreadsheets that never grew horizontally and never had date related headers that lived on more than one row! 😛
--Jeff Moden
Change is inevitable... Change for the better is not.