How to create and save a DTS package template (Enterprise Manager)

How to create and save a DTS package template (Enterprise Manager)

To create and save a DTS package template

1. In Data Transformation Services (DTS) Designer, right-click the design sheet of a DTS package, click Disconnected Edit, and stub out property values that will be entered later by template users. Repeat as needed.

   You stub out a property value by replacing it with a label or instruction or by deleting the current value.

2. Right-click the design sheet, click Add Text Annotation, and then add labels and instructions. Repeat as needed.
   
   
3. On the Package menu, click Save.
   
   
4. In the Package name box, type a name for the template and optionally any passwords.
   
   
5. In the Location list, click Structured Storage File.
   
   
6. In the File name box, type a name for the package template and change the file suffix from .dts to .dtt.
   
   
7. Click the browse (...) button to select a directory location to save the template.