/ssis

helper for ssis

Primary LanguageXSLT

scd.xsl

This stylesheet extracts the mappings used in the Slowly Changing Dimension Components in a SSIS dtsx file along with the SCD-Types used for the fields. It produces a very simple html document.

Usage:

  • process on the commandline:
saxonb-xslt -o result.html your_ssis_package.dtsx scd.xsl
  • in-document:
    • Add <?xml-stylesheet type="text/xsl" href="scd.xsl"?> to the dtsx file right after the <?xml version="1.0"?>.
    • Place the scd.xsl file in the same directory as the dtsx file.
    • Open the dtsx in the browser (tested with firefox).

n.b.:

  • xslt 2.0 is needed
  • tested with sql server 2008r2