title: How to insert a row into a dataset using SSIS?
body: <p>I'm trying to create an SSIS package that takes data from an XML data source and for each row inserts another row with some preset values.  Any ideas?  I'm thinking I could use a DataReader source to generate the preset values by doing the following:</p>
  
  <pre><code>SELECT 'foo' as 'attribute1', 'bar' as 'attribute2'
  </code></pre>
  
  <p>The question is, how would I insert one row of this type for every row in the XML data source?</p>