ExecuteSQLTask Output

microsoft.public.sqlserver.programming

27 Jan 2006 6:29 PM

sql guy

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.