It kind of sounds that way. You may actually have a loop within a loop.

I would recommend getting comfortable with one loop for now (make sure you know how...

In order to "prime" a forEach task in SSIS:

- Create an Execute SQL Task and drag its output to point to the forEach object. Put whatever connection info...

This is a basic pivot operation. Unless you get "fancy", you would need to know how many issues you would need to pivot out, and you'd need a consistent...

The UPDATE() can be confusing. It's detecting whether a column was included in an update, not necessarily whether the value of a column for a specific row was ACTUALLY...

Yes - for XML PATH is very nice, especially with complex formats. With EXPLICIT set up as a UNION (and every node and level needing to be defined), PATH...

By the way - you didn't mention the version of SQL Server you're using (it makes a difference).

For example - if you are using SQL 2005 or higher, you...

Michael Meierruth (5/10/2010)

The cathedral in Milan took forever to build.

And now its bowels...

So that becomes what -

- MCSHT (Microsoft Certified System Humor Technologist)

Assuming you have a solid ordering method in mind - I'd recommend using your running total concept. Jeff Moden has a VERY high speed way to do this in...

We've had a few colorful names for some processes:

- "mentat architecture": the results of guessing what the requirement will end up being AFTER we're done developing the project...

Good to hear. I was wondering why it would be at different levels (not terribly uncommon in XML, but SSIS tends to not much care for that from what...

Let's try this a different way. Do you have specific XML files you'd expect these to work against?

Are you expecting them to work interchangeably? Because one is 5 levels down, and the other is 7, so I don't think they could operate on the same files,...

Have you taken a look at the dependencies? There's a system view called sys.sysdepends which should have a LOt of that data.

Try:

Set Statistics TIME on