Hmmm, apparently SSIS does not allow hand-made loops like that (I had never tried it before). Let me see if I can find something else...

jose_anisha (4/19/2009)

---

I have a huge table to which i need to add new columns periodically....also i have and array temp() which contains the new set of columns to be...

Well "Edition 8" is SQL Server version 2000, which is probably the problem.

I think so, yes. At a minimum you can have a script task that your SQL task flows to on-error when err_cnt = 3 flow to the same next...

OK, Cade, here is the No Cursor, No While Loops solution that I came up with to your original question. I cannot be sure however because I do not...

You don't link directly to them as you are doing here. Instead, you create either Synonyms or Views in your local database that points to them.

I like...

Cade:

Not sure what this is showing us?

Cade.Bu (5/5/2009)

---

you have a "SELECT TOP" but no "ORDER BY" clause. Without that the rows actually returned through the TOP clause are non-deterministic. Is that really what you want or...

Yes, I think that CLR is probably your best solution, but not because it is necessarily faster for any direct solution (I frankly doubt that it is), but because it...

What would you like the UDF interface to look like?

Jeremy Brown (5/5/2009)

---

No offense to anyone with a CS degree but its probably going to be the case where most people who have a CS degree will say that its...

What is your college degree in?

BS in Theoretical Mathematics.

When I started college in 1975 I had already been programming for almost 5 years, however, there weren't any schools that offered...

Cade:

One thing that I just noticed, in the dynamic SQL statement that you construct in the inner loop:

SET @SQLSTMT='UPDATE A SET REFNM5=''' + @BOXID

+ ''' WHERE SERNUM IN (SELECT...

Cade: Just want to confirm: are you on SQL Server 2005? If not, then what version are you...

Alvin Ramard (5/5/2009)

---

David Burrows (5/5/2009)

---

Lucky for the OP that is was not Jeff, Pork Chops at...