
Question:
How to loop through / access values of RecordSet Destination in SSIS Script Task.
Solution:1
Ok got this done as
OleDbDataAdapter oleDA = new OleDbDataAdapter(); DataTable dt = new DataTable(); oleDA.Fill(dt, Dts.Variables["containerHeader"].Value);
once datatable is filled can do looping on it.
Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
EmoticonEmoticon