The last time I used XSLT was in a Microsoft SSIS package to decode XML payloads into database rows that could be merged into SQL server tables. Before I did t

The last time I used XSLT was in a Microsoft SSIS package to decode XML payloads into database rows that could be merged into SQL server tables. Before I did this the previous engineer had written a bunch of stored procedures to do this that was both brittle and slow (processing time was 11 hours) but the SQL was fairly decent. Once I used XSLT to do this the task ran in under 90 minutes and it was far easier to maintain (new fields, changing columns, etc).