Uncategories Tutorial :Looping RecordSet Destination in SSIS Script Task

Tutorial :Looping RecordSet Destination in SSIS Script Task

12:00


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
Next
« Prev Post
Previous
Next Post »
Subscribe to: Post Comments (Atom)