Revenant (4/22/2012)

---

Koen Verbeeck (4/22/2012)

---

Indeed. But I usually don't connect to 2008R2 with SSMS 2005, so I still...

I haven't found official documentation for this, but I believe the SCD component is case sensitive.

Lynn Pettis (4/22/2012)

---

Revenant (4/22/2012)

---

Lynn Pettis (4/22/2012)

---

Sometimes I wonder if some people posting questions even try to solve their own problems. Doesn't help when they start mixing code posted by...

Have you read the article I linked to?

Indeed. But I usually don't connect to 2008R2 with SSMS 2005, so I still had to make...

If I'm not mistaken, the Excel file should already be created before you attempt to write data to it.

It is a logical layer between the datawarehouse and the reporting tool.

It's a way of dimensionally modelling your data, which represents the Kimball methodology a lot.

Unified Dimensional Model

opc.three (4/20/2012)

---

You could start with Microsoft® SQL Server® 2008 T-SQL Fundamentals by Itzik Ben-Gan. I have not read this particular offering from Mr. Ben-Gan but have been impressed with most...

Easy guess.

Great question, but it would good to mention that HTTP,SOAP was deprecated in SQL Server 2008 R2 and ultimately removed in SQL 2012.

I believe it will stop.

Is it not an option to execute your packages within a SQL Server Agent job?

SSIS: log errors and warnings.

bharathgceb1 (4/20/2012)

---

Thanks for your reply.

Yes in Reorganize index task we can selecttables in drop down.

But my requirement is i need to reorganize index only for those tables having fragmentation between...

It depends. What is your source system? Can it handle extra load such as the CDC process?

Do you need to capture intermediate updates or only the final one?

Don't you have a dropdown to select the tables?

Selectively rebuild indexes with SQL Server maintenance plans[/url]