A few years back, I wrote a blog post about using an SSIS object variable as a data flow source. In that post, I described how you could load a set of query results into an object-typed variable in SQL Server Integration Services and then use that in-memory data as a source within a data flow. In the comments and...
The post Reusing a Recordset in an SSIS Object Variable appeared first on Tim Mitchell.
