InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 06:24:07 GMT20http://www.sqlservercentral.com/Forums/Topic1381313-391-1.aspxYou can use a ForEach Loop task to read from a recordset object and assign the column values from each row to a variable.Tue, 06 Nov 2012 07:15:08 GMTsestell1http://www.sqlservercentral.com/Forums/Topic1381313-391-1.aspxYes, there's only a destination, not a source.You need to write a script component as a source to read from the object variable where the recordset is stored in.Somehow using a table seems easier to me :-)Mon, 05 Nov 2012 23:36:33 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1381313-391-1.aspxOk Found out there is recordset destination-never used that one.Anything to add?Mon, 05 Nov 2012 16:56:42 GMTpeacesellshttp://www.sqlservercentral.com/Forums/Topic1381313-391-1.aspxI have three column values (startdate, completedate, recordcount) that i get in txt audit file. I need to use those values downstream in my ssis package. I want those values in the ssis variables. Is there a way i can map them directly to ssis variables and use them instead of loading them into a table.many thanks.Mon, 05 Nov 2012 16:44:31 GMTpeacesells