Hi I am writing an app in c# that will create a package and utilise the
executesql task to execute some sql. from these task, i want to trap the
output via a varaible (or any facility available). my code is shown below:

TaskHost thSQLTask = _Package.Executables.Add("STOCK:SQLTask") as TaskHost;
ExecuteSQLTask myExecTask = thSQLTask.InnerObject as
ExecuteSQLTask;

myExecTask.Connection = connectionManegerName;
myExecTask.SqlStatementSource = executableSQLStatement;
myExecTask.SqlStatementSourceType =
SqlStatementSourceType.DirectInput;
myExecTask.ResultSetType = aResultType;
myExecTask.TimeOut = 0;

however, i am not sure how i can get the output of the task since the task
does not expose any property through which i can wireup a variable.

any help please.