DTS Programming
CreateProcessTask Object
The CreateProcessTask object runs a Microsoft® Win32® executable or batch file in the context of the Data Transformation Services (DTS) package.
Use the ProcessCommandLine property to specify the file to be executed and command line parameters. You can set a Timeout for the executed process. You can specify TerminateProcessAfterTimeout, or also FailPackageOnTimeout.
Collections
| Properties Collection |
Properties
| Description Property | SuccessReturnCode Property |
| FailPackageOnTimeout Property | TerminateProcessAfterTimeout Property |
| Name Property | Timeout Property |
| ProcessCommandLine Property |
Methods
| Execute Method |
Remarks
The CreateProcessTask object is compatible with Microsoft SQL Server™ version 7.0. For information about an extended version of this object, see CreateProcessTask2 Object.