Discussions under Issues 2: Using the Component (Design-Time)

If you have questions about using this project, please search/browse for an answer here before you post. Given the number of discussions you see, it's quite likely someone else has asked the same question you have.

If you have a reproducible bug, please go to the Issue Tracker to see if it's been observed by someone else. If it hasn't please file an Issue with COMPLETE information about how I can reproduce it - otherwise it'll never get fixed.

If you have a suggestion for the project, go to the Issue Tracker to see if it's already been suggested (it probably has) and you can up-vote it to let me know it's important to you. If it hasn't been suggested yet, please add a new feature request in the Issue Tracker.

Keep in mind that this project keeps going solely out of the passion that I have for data warehousing using Microsoft's toolset - this isn't my job. Honey will get you more than vinegar, so keep your posts respectable.

Update history for SCD Type 1 Changes

first post: howetj wrote: Hi Before closing this discussion thinking - this dude does not kn...

latest post: WeeeBob wrote: Ahh a little clearer now. I tend to just go for option 2 for Type 1...

How to use date from source system as eff_dt using KSCD

first post: lordrobbery wrote: Hi all, My question's about using date from source system as eff...

How to use given column for date in KSCD

first post: kleach wrote: First of all.. thank you for saving all of us the work to make thi...

latest post: toddmcdermid wrote: Re #1 - The problem I have is squaring this circle: Your dimension...

problem with effective date values

first post: Joe9 wrote: While configuring Kimbal SCD transformation, I've faced up a probl...

latest post: Joe9 wrote: It was marked as Beta release two days ago, so I used v1.5. I tried...

Record is already exists in Dimension table but still Kimball SCD Component is Identifying it as a new record every time I run Package

first post: AnujaETL wrote: Hi Todd, I am sorry I posted question on http://social.msdn.microso...

latest post: toddmcdermid wrote: Replacing the component should have absolutely no effect on runtime...

Issue mapping special members columns to existing dimension columns

first post: jasonplenty wrote: I am experiencing an issue in only some of my SSIS packages where ...

latest post: Tjomme wrote: Hello Todd, Indeed, I found the issue. It is mandatory to link an i...

SCD CurrentRecord trouble

first post: Plexar wrote: I can't make the CurrentRecord in the SCD v1.5 transformation work...

latest post: toddmcdermid wrote: Start placing Data Viewers on the inputs and outputs of the compone...

Audit value for new rows

first post: mdonne wrote: In the past, I have stored an audit key, unique to the execution of...

latest post: toddmcdermid wrote: Your interpretation is correct - that's exactly what I do. I have ...

New vs. New SCD2

first post: robshobs wrote: I'm guessing this may be a simple an obvious question. What is th...

latest post: toddmcdermid wrote: The "New SCD2" output is for the "new version" of SCD 2 rows. You...

SCD2 Data Handling, first record's effective data ...

first post: iwcoetzer wrote: Hi, By default the first record's effective date is 1753 ...... I w...

latest post: WarehouseMouse wrote: That code should not be necessary. Are new records being given an ...