Ah, finally an SSIS question. Thanks!

In my opinion not really a brilliant article:

Get month names ordered using recursion[/url]

But with a great discussion! 🙂

mtillman-921105 (3/13/2012)

---

Ha! That's about right.

'Hate to beat up on...

There aren't any XML destination adapters available out-of-the-box.

It's possible that there are 3rd party adapters available on the web for purchase.

I don't think you can achieve your requirements without touching the SSIS packages.

There's no way of finding out how many rows were affected without logging it somewhere.

With the little amount of information provided, there's no...

All I can say is that the ADO.NET enumerator gives back a resultset with at least 3 columns and the sheetname is the one with index 2. All the others...

andrew.diniz (3/13/2012)

---

Consider the scenario where multiple data regions, each sourced from different tables, are to be fed by a single month parameter.

Which table do you source your month parameter...

I guess you create the temp table in another task?

You need to set the property RetainSameConnection of the connection manager to TRUE.

How did you configure the For Each Loop containers?

Which iterators did you use?

Charmer (3/13/2012)

---

sorry about that..i was...

What's the criteria for "first row"?

There isn't such a thing as order in a relational table.

It depends.

Is there conditional logic in your code (IF ... THEN ... ELSE), do you have a WHERE clause, do you do some JOINs, do you have a HAVING clause,...

And if you set it to Text?

I prefer to use a calendar table, even more clean 😉