Tutorial :Looping RecordSet Destination in SSIS Script Task



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
Previous
Next Post »