You can use GROUPING or GROUPING_ID to check if a row is a detail row or a total.

And how exactly would you like to go from this result set to the other? They have almost nothing in common.

What does the query currently return?

It would be helpful if you showed us what this query returns and what your desired result is.

What if you run the wizard as administrator?

There are two options:

* just add extra columns to store the different catagories. Easiest solution by far, but the least flexible.

* snowflake to a category dimension and add a bridge...

Very interesting question, thanks.

SQL_Surfer (1/20/2014)

---

For new packages and old packages; package will reside in MSDB. I am trying to avoid RDP access to users to logon to server and deploy that way. I...

That statement is not justified at all.

Why don't you like SSIS...

No problem...

Easy one, thanks.

nonghead-webspam (1/17/2014)

---

So, if I want to do extensive variable and data manipulation in the process, is it better to use an external compiled module? I've done that in the...

blasto_max (1/17/2014)

---

Koen Verbeeck (1/17/2014)

---

You can see a connection manager as a factory creating connections.

Each time a connection manager is used by an SSIS component, a new connection is created.

If you...

The information messages are normal, that's just the native client version number being upgraded in the connection strings.

The errors mean you have a protection level with a password, set it...

I already had your query...