Are SQL Server tables involved at any point in this process? Or is this a file-to-file job?

I think you meant:

"Stll nutin 2 wk wit 4 ddl n smpl dta"

I have, though not enough to pretend that I am particularly adept with them.

But what I meant is that XML files are so flexible in structure that the XML source...

We've done that. The Datepart solution works in pure SQL Server.

84gopi (7/24/2012)

---

Hi,

My report is cross tab & uses relational modelling now tel me how can I get the required week numbers in my cross tab report based on the season...

Sorry - should have made my answer a bit clearer.

select datepart(week,getdate())

With sample data and DDL someone...

Koen Verbeeck (7/23/2012)

---

Jeff Moden (7/23/2012)

---

Someone just gave me some incentive to study SSIS. It's called XML SOURCE. Yes, I've already (recently, in fact) written some T-SQL to do...

Aha: XMLSQLNinja - just what the doctor ordered! 🙂

That's a cool solution - can you explain how it works?

And if you've got time, perhaps you could also have a go...

Beat me! And I missed the IsNull on ColC, oops.

Have a look here[/url].

You need a nested if...then construction along the lines of

IsNull(ColA)? (IsNull(ColB)? ColC: ColB) : ColA

It's about time you started thinking...

Did you add your variable to the Script Task's 'ReadOnlyVariables' property?

Are you trying to have dynamic columns in your data flow?

If not, what is the purpose of the variable?