Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 03, 2013 01:10 PM by Radek_K_SQL
Feb 22, 2006 10:44 PM|LINK
I have added a Slowly Changing Dimension transformation to an SSIS package and have launched the Wizard to edit it. After selecting the source (a SQL Server 2005 instance), if I select a very large table (9+ million rows), I'm encountering
two strange behaviors:
1. The wizard hangs for several minutes before displaying the columns from that table.
2. The wizard does not display the primary key column. This, of course, is the column I want to designate as the "business key", but can't because it's not displayed.
I know this is more like a fact table than a dimension, but this is not a data warehouse. This is just a very large table, and I need to update a field in certain records based on the contents of a source text file. Is there another transformation
I should use to perform updates?
Feb 03, 2013 01:10 PM|LINK
I know that this post is a bit out-of-date now but maybe someone still have a similar issue with SCD wizard therefore I will write what helped me. Generally SCD wizard doesn't work with IDENTITY columns. So just create new table based on previous schema
but ommit IDENTITY clause and SCD will buy it ;)