Difference between DataReader Destination and Recordset Destination
What is the difference between DataReader Destination and Recordset Destination in dataflow task ?
May 18th, 2012 1:38pm

The datareader destination is kind of an odd destination. What it will allow you to do is actually provide a datareader to an external application which has eexcuted the SSIS package programatically. There is some detail here: http://msdn.microsoft.com/en-us/library/ms135917.aspxChuck
Free Windows Admin Tool Kit Click here and download it now
May 18th, 2012 1:50pm

Hi nadirsql, The Recordset destination does not save data to an external data source. Instead, the Recordset destination saves data in memory in a recordset that is stored in an Integration Services package variable of the Object data type. After the Recordset destination saves the data, you typically use a Foreach Loop container with the Foreach ADO enumerator to process one row of the recordset at a time. The Foreach ADO enumerator saves the value from each column of the current row into a separate package variable. Then, the tasks that you configure inside the Foreach Loop container read those values from the variables and perform some action with them. For more information about it, please see: http://msdn.microsoft.com/en-us/library/cc879316.aspx Thanks, Eileen
May 21st, 2012 5:04am

Hi nadirsql, The Recordset destination does not save data to an external data source. Instead, the Recordset destination saves data in memory in a recordset that is stored in an Integration Services package variable of the Object data type. After the Recordset destination saves the data, you typically use a Foreach Loop container with the Foreach ADO enumerator to process one row of the recordset at a time. The Foreach ADO enumerator saves the value from each column of the current row into a separate package variable. Then, the tasks that you configure inside the Foreach Loop container read those values from the variables and perform some action with them. For more information about it, please see: http://msdn.microsoft.com/en-us/library/cc879316.aspx Thanks, Eileen
Free Windows Admin Tool Kit Click here and download it now
May 21st, 2012 5:06am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics