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?
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 ;)
mskone
Member
114 Points
25 Posts
Slowly Changing Dimension Wizard doesn't display destination table primary key column
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?
Radek_K_SQL
Member
2 Points
1 Post
Re: Slowly Changing Dimension Wizard doesn't display destination table primary key column
Feb 03, 2013 01:10 PM|LINK
Hello<
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 ;)
Cheers!