Professional SQL Server™ 2005 Integration Services

3.6. Execute Process Task

The Execute Process task will execute a Windows or console application inside of the controller flow. It's been much improved on since SQL Server 2000, and now it is more robust in its error handling. For example, you can now write any errors from the execution to a variable that can be read later. Also, any output from the command file can be written to a variable.

The Process page in the Execute Process Task Editor (shown in Figure 3-7) contains most of the important configuration items for this task. The RequireFullFileName property tells the task whether it needs the full path to execute the command. If the file is not found at the full path, the task will fail. This is useful only when you're worried about a second copy of the file existing in a folder somewhere that is referenced by the Windows PATH. For example, if the file exists in the System32 directory, you wouldn't have to type the full path to the file.

The Executable option is the path and file name to the executable you'd like to run. This does not contain any types of switches or parameters you'd like to pass. The Arguments option contains those types of items. For example, Figure 3-7 shows that the task will execute expand.exe and pass in the cabinet from which you want to extract and where you'd like it to be extracted. The WorkingDirectory option contains the path from which the executable or command file will work.

The StandardInputVariable parameter is the variable you'd like to pass ...