Frequently Asked Questions

Q: The component isn't working - I get errors at design time!

A: Review the Troubleshooting page for ideas - but in most cases it turns out to be an installation problem. Try re-installing.

Q: The component isn't working - I get errors at runtime!

A: Review the Troubleshooting page for ideas. Typically the reason you get errors at runtime is that the component needs to be installed on the server you're running the package on.

Q: The component runs, but sends all rows to the Invalid Input output.

A: Put a Data Viewer on the Invalid Input output so that you can see the "Invalid Input Error Description" that will tell you why the row was sent there, and the "Invalid Input" column which tells you which input the row came from. Typical reasons rows show up on the Invalid Input:
  • The business key had NULLs in it.
  • A (non-business key) column had a NULL in it when you configured the component to refuse NULL values for that column
  • A duplicate row (same BK) was seen on the Source System or Special Members inputs, or an overlapping date period for the same BK on the Existing Dimension input

Q: The component isn't working like I think it should.

A: Make sure you understand how Slowly Changing Dimensions work (check Wikipedia and Kimball articles), then post details as a discussion item.

Last edited Jan 24, 2010 at 8:14 PM by toddmcdermid, version 2


benschmucker Aug 23, 2012 at 8:31 PM 
I've been using the component and it is working great. I'm currently at a client that is moving from SQL Server 2008R2 to SS2012. I cannot get the component to show up in the toolkit (I understand you have to add it manually in 2008/2008r2, but in 2012 it adds these automatically and I cannot see it)... Any ideas?

bcruz03 Dec 28, 2011 at 2:56 PM 
I installed the component on a VSS Team Sytem 2008 and when selecting to add custom toolbox items the VSS closes. Tried re-intsalling the product with same result. Do you have a solution to the problem? Thanks

Codersvalley Jul 18, 2011 at 3:17 PM 
Q: Is the Component intended for dimension tables only, is not is there any other example to load fact tables using kimbal's method.

mickealdavis Feb 23, 2010 at 1:58 AM 
Q: The Compent Crashes with object not set erors

A: It Really - REALLY does not like blanks at the end of a business key field. Regardless of whether ignore trailing blanks is ticked on or off for the business keys, it crashes when the business key ends in a blank.