You create the aggregations and redeploy the cube?

The easiest solution would be to execute child package 1 in another loop, and connect it to your original loop with an OnCompletion precedence constraint.

Any reason you don't do this with the regular FTP task?

There aren't exactly any changes between 2008 and 2012 regarding how SSRS works internally for rendering reports.

So if it didn't work in 2008, it won't work unfortunately in 2012.

GilaMonster (3/11/2014)

---

Koen Verbeeck (3/11/2014)

---

Grant Fritchey (3/11/2014)

---

By the gods, people get hung up on the weirdest darned things. They can focus like a laser on stuff that's just a waste of...

I...

Someone gives this guy the persistence medal.

http://www.sqlservercentral.com/Forums/Topic1549110-391-1.aspx#bm1549735

How do you test your output?

Did you use SELECT or PRINT?

free_mascot (3/11/2014)

---

Koen Verbeeck (3/11/2014)

---

Great question.

Although the IDENTITY property doesn't always transfer:

When an existing identity column is selected into a new table, the new column inherits the IDENTITY property, unless one...

Oooh. Sounds like an exciting thriller.

Looks like someone has a split personality.

http://www.sqlservercentral.com/Forums/Topic1549262-2799-1.aspx

Charmer (3/11/2014)

---

Koen, suggest me what should I do ? I did not rename the server. Assume that i had renamed the server, what would I do for that? explain me...

Longer <> performance...

Great question.

Although the IDENTITY property doesn't always transfer:

When an existing identity column is selected into a new table, the new column inherits the IDENTITY property, unless one of the following...

First you need to create a login on the server level (in the security node) and map this to a user on the database level.

Then you assign this user to...