1. XML

• SSIS package and other object definitions are stored in standard XML format.

• Extension of a package is “.DTSX”, here ‘DTS’ stands for Data Transformation Services and ‘X’ stands for XML.

• We can edit the raw XML for an object or to use a graphical designer, with related menus, toolbars, and dialog boxes.