Does anybody know of a good online tutorial on how to use the SSIS component 'Recordset destination' ?Mr Shaw

http://msdn.microsoft.com/en-us/library/cc879316.aspxMr Shaw

Have a look at my blog post for application of Recordset destination: http://beyondrelational.com/blogs/sudeep/archive/2010/09/09/loop-through-each-record-in-a-text-file-recordset-destination.aspxMy Blog | Ask Me

I have setup the foreach loop to enumerate through the Record Destination data... It only reads the first value.... What could have gone wrong?Mr Shaw

You would have to check how many records are bing written to the obj variable using the recordset det(use a rowcount before the recordset detination). Hope you are using object variable with correct scope etc. I donot see any other reason why this should happen. Could you put a screen shot of the record set destintaion and the foreach loop task settings.My Blog | Ask Me