Can you try the following:

the OLE DB Destination has the property OpenRowSet, which specifies which table the data needs to be written to.

Manually set this to the destination table you...

Again, is this an interview question?

What do you mean with dynamic reports?

OLAP cubes, such as SSAS, are just a datasource for a report.

You can report on many sources, such as...

Is this an interview question?

Anyway, this is more a question for the administration forums.

Furthermore, the question is too vague. There are many types of database mirroring.

But you can start here:

http://msdn.microsoft.com/en-us/library/ms151799.aspx

The red arrow in the control flow?

GSquared (3/3/2011)

---

If anyone's interested in what I've been working on the last six months or so, last night (late) we launched http://www.VisitOrlando.com.

While you won't see my ETL and database work...

Don't apologize,...

Sorry to point out an error again, but now you say in the first...

Low priority? This happens...

Lowell (3/3/2011)

---

via SSIS, it's not possible; you'd have to automate excel in order to do that: formatting codes for excel cells are not exposed.

see this thread for Koen's more complete...

You'll have to use a script component to do that.

You need to keep the value of the first column of the previous row in a variable and check the value...

Phil Parkin (3/3/2011)

---

Koen Verbeeck (3/3/2011)

---

Dammit, if that is the solution, I've wasted 5 minutes of my life typing an answer while continuously...

Dammit, if that is the solution, I've wasted 5 minutes of my life typing an answer while continuously checking the SSMS GUI...

Try using the GUI in SSMS to do this task. Go to the Securables tab of the specific user...

Jeff Moden (3/3/2011)

---

I agree that the cursor will likely be a problem but the Temp Table won't be. It's just a different kind of memory usage. I do...

Step 1: Do you have experience working with the Microsoft BI platform (SSIS, SSAS,...