stricknyn (11/20/2009)

---

CozyRoc (11/20/2009)

---

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

I would love to just load my data in data flow task right into a .NET dataset. Currently in dataflow task 1, Im using a recordset destination with the SSIS object variable set as rsPayeeSummary. The other dataflow tasks (per the previous post) then use rsPayeeSummary. What's the recommended route to instead load a .NET data table/set into rsPayeeSummary instead of a recordset destination?

Thanks,

Strick