CODEWITHSUNDEEP
sql-serverssis
Sreedhar
Sreedhar

Reputation: 30045

Looping RecordSet Destination in SSIS Script Task

How to loop through / access values of RecordSet Destination in SSIS Script Task.

Upvotes: 2

Views: 3002

Answers (1)

Sreedhar
Sreedhar

Reputation: 30045

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.

Upvotes: 3

Related Questions