you can read values of parameter with a first data flow task into an object type variable, and then use a foreach loop to loop through this object variable with ado enumerator, and put second data flow task with oledb source with parameters then you can set parameter value with the value fetched from foreach loop . this was whole schema if you need more details let me know where you need deeper information?http://www.rad.pasfu.com