<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>

I've never tried it, but it looks like you might be able to use a
Derived Column transformation
to do it: set the expression for attribute1 to
```
"foo"
```
and the expression for attribute2 to
```
"bar"
```
.
You'd then transform the original data source, then only use the derived columns in your destination.  If you still need the original source, you can Multicast it to create a duplicate.
At least I think this will work, based on the documentation.  YMMV.