c# - Passing updated objects in SSIS -

at job i've faced following problem: sql or t-sql slow if gonna manipulate big numbers of data. mean millions or billions rows , ways (when need use while inside while or recursion in recursion) ssms (ms sql) doesn't work fast (i tried indexes , many others sql tips). know other programming languages works faster way- i'm trying pass data sql c# (using ssis sql , script tasks) or java (netbeans). please me , share features how pass object variable, had been updated in ssis script tasks sql task (insert). i'm not knew in ssis, 70% of experiance there building dwh, i've used script task messege box last time.

i know firsly need our array (table) sql in sql task , pass object varialbe. second step update data in script task. third object step 2 , insert sql updated data. please me 2nd , 3rd steps? how create output variable in c# script task (for example have table 1 column , want increment values 1) , move next ssis block?

i want describe example more:

1. we have table 1 column named , value 0;
2. we pass value table in full result set (sql task);
3. how make changes in c# script task , return new value of variable got previous step?

thanks.

create new variable of type object. use data flow task send data destination object variable , pass variable script task. object can cast datatable type in script task so:

var data = (datatable)dts.variables["user::myhugedataset"].value; 

hope helps, suggest revisit requirements , see if there set based way of accomplishing in sql. doing trying here bad idea.