MS SQL Server DTS - Problem with ExecuteSQK Task in SSIS

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Problem with ExecuteSQK Task in SSIS

sql guy

2006-01-27, 1:23 pm

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 = connectionManegerNam
e;
myExecTask.SqlStatementSource = executableSQLStateme
nt;
myExecTask. SqlStatementSourceTy
pe =
SqlStatementSourceTy
pe.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.

Sponsored Links