oracle - Ssis use an object variable for a condition -

i have execute sql task assign the result of sql task many of variables result set. works if use object type type of variables. after that, want use variables set constraint expression.by ssis not allow object type variable these operation. there ways fix problem? here sql statement is:

select (select count(*) s5 random_table rownum < 100) s5, (select count(*)  s6 random_table_2 rownum < 100) s6 dual 

thanks!

data types cannot change within ssis, unless base type object. however, can't do anything, expression-wise, variables of type object.

general purpose approach use foreach enumerator shred result set. each row in object variable, can address individual column elements , assign those typed variables (which use in precedent constraint).

specific purpose question, change execute sql task populating variable of type object. supplied query ever going return 1 row of data (2 columns that's arbitrary). in special case, can modify resultset of execute sql task singlerow (instead of none or full have set). singlerow property set, instead of dumping single variable, assign typed ssis variables specific columns.

examples

• https://stackoverflow.com/a/28503036/181965
• https://stackoverflow.com/a/24389822/181965
• https://stackoverflow.com/a/9162133/181965
• https://stackoverflow.com/a/21762589/181965