SSIS: Set based Update | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SSIS: Set based Update

Dear friends,
if i’m talking about SSIS and SCD, SSIS SQL server 2008 works better than SSIS SQL server 2005 ?
SSIS 2008 have a set based oriented operations to resolve SCD ? set based UPDATE for real?
Can anybody give me please a real example about it? [*-)]
Thank’s

Check the following blog post…
http://sqlblog.com/blogs/andy_leonard/archive/2007/07/09/ssis-design-pattern-incremental-loads.aspx

What is your requirement in terms of SCD, as 2008 feature is introduced by Ralph Kimball and it is fully supported.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |