This Microsoft® Visual Basic® sample demonstrates how to run a Microsoft Win32® application from a Data Transformation Services (DTS) task. The sample creates a DTS package and a custom task that runs the Windows Calculator for 15 seconds.
Depending on the FailPackageOnTimeout and FailOnError settings in the sample, an error message is returned if Calc.exe does not exit in 15 seconds.
C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Dtstasks\DTSExecProcess