resultset from EzExecSqlTask

Oct 1, 2013 at 9:02 PM
I'm trying to assign a value from a result set from a ezExecuteSqlTask, but the code won't compile. I'm using the exact same pattern as done here :

http://www.ssistalk.com/2008/12/31/ssis-using-the-api/

...but but the ResultSetBindings property is not found :

sourceEntitySql.ResultSetBindings.Add();

Any advice? :)
Nov 26, 2013 at 6:08 PM
This constraint is so frustated!

To resolve, you need to open the solution, go to EzExecSqlTask class, and add the following method:

public IDTSResultBindings ResultBindings
{
        get { return (host.InnerObject as ExecuteSQLTask).ResultSetBindings; }
}

This should works!