That's a good informative post.

Have you isolated the part or parts of the package which are taking a long time? If not, it might be worthwhile adding some logging to...

COALESCE is not an SSIS function, unfortunately.

Nice article - thanks for the link. When I read absolutes (like 'meaningless') my brain subconsciously challenges them. I still think it was the wrong word 🙂

ChrisM@Work (7/25/2012)

---

This looks very much like a homework question, in which case Anthony's reply is a good place to start.

Don't forget that TOP is meaningless without ORDER BY, and...

Jeff Moden (7/24/2012)

---

SGT_squeequal (7/24/2012)

---

excuse double post i replied to the other post before seeing the link

you could achieve your reslutls by using patindex

PATINDEX('%[0-9]%',col1)=0

if there is a value between 0 and...

I agree with Jack.

But I can envisage a revolting non-programming option.

Create a derived column which is a massive nested replace - to replace any of 0, 1, 2, ...,...

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