How long is ages?

I'm not surprised - firing off 80000 tasks in ANY package, whether you're in a loop or not, is going to take a long time. "Ages" in fact!

-Jamie

I've got two of them and my parents have another. I don't know anyone, in or out of Conchango, that has played it.

To be fair...I don't think that was the point...

Don't talk to me about B&N and Project REAL. Conchango did the original proof of concept for that project and then lost it to IntelliNet. Me? Bitter? no way!!!!! 

Crispin,

I think yours is a valid point. What I guess Kirk means is if you can filter the data (either in the cache or the pipeline) then do it. By filtering I...

On my current project we are still in the dev and test phase so we haven't thought about these things yet but I'll answer as best I can.

How are we...

The Sprint PPC-6700 that Greg put a link up to is the same as the i-mate K-Jam that I was chuntering on about - just a differrent branding that's all. They're...

I'm a big fan of the i-mate K-Jam (it may be called something different in the US) - in fact I'm a fan of Windows Mobile devices in general.

People talk about music...

No. In fact you can't do that anyway - the minimum thread number is 2.

-Jamie

As far as I am aware there is no guarantee of the order in which the rows will occur once you split them into seperate streams of execution. I stand to...

Well, you could combine them into a single insertion using a UNION ALL. Thereafter you can use a SORT transform to put them in any order you like. If all...

Noa,

It is not possible to control in what order rows from the same source to differrent destinations are processed. In fact, you cannot control which of the destinations gets inserted to first.

The workaround...

JV,

100 different people will most likely give you 100 different answers to that question. My answer would be "The biggest difference is the seperation of workflow from data-processing"

You may find...

JV,

Just to clarify, SQL Server Integration Services (SSIS) is available in Standard edition right thru to Enterprise. The only place is you don't get it is on SQL Server Express.

The...

David,

Why not just use an Execute SQL Task with the query:

UPDATE tblTrans SET stageFlag = TRUE WHERE stageFlag IS NULL

???

Does that work for you?

-Jamie

dtevlin,

Is that really "proven" or is it just accepted wisdom? I'll grant you SQL Server 2000 won't handle the data volumes that you are talking about and I am definately...