You can definitely load your data directly in data set. However you have to implement a script component for that. Regarding the release of the COM object I would do the following:

Imports System.Runtime.InteropServices

...

Dim dt As DataTable = New DataTable

Dim da As OleDbDataAdapter = New OleDbDataAdapter

Dim rs As Object = Me.Variables.rsPayeeSummary

da.Fill(dt, rs)

Me.Variables.rsPayeeSummary = dt

'release objects

Marshal.ReleaseComObject( rs )

rs = nothing

dt = nothing

da = nothing

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/