What if you put this to True?

I would check the day in the control task either with a script task or with an Execute SQL Task. Put the result in a boolean variable, for example @firstDay....

Thanks for the question.

I was looking for a catch, but apparently there was none 🙂

Nice question, thanks.

Thanks for the question.

The derived column won't magically add "001" to a number.

My guess is they are already there in the Excel file, but formatting doesn't show it to you.

About the missing 0's,...

The only thing I find is this blog post:

Using XML Source

However, the XML in the example seems to have a better nested structure than yours.

The article says:

These outputs are linked...

Grant Fritchey (4/5/2012)

---

Koen Verbeeck (4/5/2012)

---

Grant Fritchey (4/5/2012)

---

Yeah, I feel for him. I've had WAY too many arguments with people demanding that I rearrange the laws of physics because they said...

If I say gravity...

And what are those multiple outputs?

Can you give more info on those outputs and on how the destination table looks like?

Sample data would be appreciated.

Been thinking for 5 minutes to come up with a better and simpler solution, but you're right, there isn't any. 😀

@Gianluca: I wish everyone posted such nicely formatted code to the forum 🙂

I think the attitude comes from a lot of frustration.

Create another proxy and use that one?