Read File Opens and copies the contents of a file specified in the source column to a destination column. The source column must be a string data type. The destination column must be a string or binary data type. Write File Copies the contents of a source column to a file specified string or binary data type. DTS Package Workflow DTS uses steps and precedence constraints to order tasks within a DTS package.
Steps define the sequence in which tasks within a package execute.
Precedence constraints sequentially link each task within a package. A task can have multiple precedence constraints. Tasks without precedence constraints operate in parallel. There are three types of precedence constraints, as shown in Table 7.5. If Task 2 is linked to Task 1 by an Unconditional constraint, Task 2 will wait until Task 1 completes and then will execute, regardless of the success or failure of Task 1.