Execute Process Task
With the Execute Process task, you can run an executable program or batch file as part of a Data Transformation Services (DTS) package. Although you can use the Execute Process task to open any standard application such as Microsoft® Excel or Microsoft Word, more often you use it to run business applications or batch files that work against a data source.
For example, you can use the Execute Process task to run a custom Microsoft Visual Basic® application that generates a daily sales total report. Other steps or tasks in the package can use the sales total report. Then, you can attach the report to a Send Mail task and forward the report to a management distribution list.
To add a DTS task to a DTS package