I have a sql query where i want each field that is outputted to be used as a variable in a stored procedure. I have everything set up and runs great with hardcoded values, but i have no idea where to start to put each field in its correct stored procedure paramater. Any help would be greatly appreciated.

Sorry for the late reply. Missed this support case.

Are you talking about x number of fields in one row or y number of rows (in first output)?

Either way you should look at the looping tutorial here:

http://www.visualcron.com/Tutorials.aspx 

You need to set the second SQL Task as a loop and in the loop settings you use For each method and paste the output there. It is important that you get the correct values so I suggest using a File write Task first to confirm that the right loop Variable works for you.

---