SSIS SCD Component

fdarrigo at 19h42
11
Jun
2010
SSIS SCD Component

We are using (or attempting to use) the Kimball Method SSIS Slowly Changing Dimension Component for SSIS from Todd McDermid (http://kimballscd.codeplex.com/).
We have run into a few issues and would appreciate some advice if anyone has used this SSIS component.

First, although, the existing dimension input columns for “SCD2 Current Record”, “SCD2 Effective Date”, and “SCD2 Expiry Date” are assigned on the first tab, when running the job against

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
SSIS Frameworks. Automatic Rollbacks, and Poorly Designed OLTP Sources
I've purchased the excellent book Microsoft SQL Server 2008 Integration Services: Problem, Design, Solution and read it cover to cover a few times.
SSIS and the SQL 2008 MERGE Statement for Insert, Update and Delete
The 'MERGE' statement in SQL 2008 seems a powerful tool for managing incremental ETL. Seems lots of examples of using from SSMS, but few (none?) of calling from within the SSIS framework. Hopefully in Denali we'll see a package object OOTB that can
Flat File Importing via SSIS - Best approach?
My company is frequently faced with the need to import and profile flat files submitted by various prospects and customers. These customers rarely provide us with a format file and when they do it is rarely accurate. Importing CSV files is slightly easier
Audit Dimensions in SQL/SSIS 2008
I've read The Micorosoft Data Warehouse Toolkit and would like to implement the audit dimension and logging set up described in that book. However, I believe the download from the book's site is for SSIS 2005. Has anyone published an updated framework for
Historical and Incremental Loading of Dimension and Fact tables
Hello I have been reading three of the Kimball books and playing with the MDWT_AdventureWorks_SSIS sample. I have learnt a lot but I have also become overwhelmed as I was new to DW/BI up until a few weeks ago. Also, the books are very detailed and ther
Forums from same category
See also
more_less
Informations

0 Replies For the topic :
"SSIS SCD Component"

This topic has been viewed 1471 times.

Last message :
11/06/2010 at 19h42 by "fdarrigo"