I have an SSIS task that executes a stored procedure. It is set to full result set. The SQL is listed below. My question is what exactly is returned to the SSIS package? The next step the previous developer has a script task that
defines a a data table and loads it with the values from dts.variables(object used to return proc resultset) A variable(obj) is then valued with the first row from the table which is "SQL_STATEMENT" whish is defined in the last select of the proc.
I am just not sure what all is returned back in the object. Can't this be done with out the script task to assign the variable? What is returned is a SQL statement that is executed later.