After upgrading to SCD for sql server 2012, we have issues with SCD component. SSIS package error out during the validation "[Dimension Merge Slowly Changing Dimension] Error: 'New' output needs co...
Id #12579 | Release:
| Updated: Dec 10, 2013 at 3:54 PM by vinay459 | Created: Dec 10, 2013 at 3:54 PM by vinay459
Issue found in version 1.6.
In an initial load scenario, where 50 million rows are passed into the Source System input, and no rows are passed into the Existing Dimension input, the DMSCD componen...
Id #12355 | Release:
| Updated: Oct 24, 2013 at 9:01 AM by hbeomadadk | Created: Oct 24, 2013 at 9:01 AM by hbeomadadk
I am using KSCD version 1.5
Scenario: A row is deleted from source and in logs its identified that this rows exist only in existing dimension but while output it is redirected to unchanged output i...
Id #11673 | Release:
| Updated: Mar 29, 2013 at 10:28 AM by SushantA | Created: Mar 29, 2013 at 9:55 AM by SushantA
When field in SQL 2008R2 is a time datatype, SSIS Dimension Merge SCD in design mode does not cause any error mapping the column data type DT_DBTIME2 , upon running the task it threw out these erro...
Id #11542 | Release:
| Updated: Feb 21, 2013 at 11:28 PM by amostay | Created: Jan 30, 2013 at 4:28 AM by amostay
I've just upgraded from v1.4 to v1.6, but I get some errors: some rows are now added to the invalid output (when using v1.4 they didn't), with Invalid Input Error Description=Overlapping SCD 2 ...
Id #11042 | Release:
| Updated: Feb 21, 2013 at 11:28 PM by edwinbrinza | Created: Aug 1, 2012 at 1:09 PM by edwinbrinza
Once in a while usually when we run a dtsx package many times a day, we end up with multiple occurrences of a current record.
Id #10967 | Release:
| Updated: Feb 21, 2013 at 11:28 PM by MrTintin | Created: Jul 4, 2012 at 3:39 PM by pilab72
Though similar issues are tracker here already, they doesn't completely map to my actual issues.
I have a quite small dimension table (<3000 rows), which is filled with the SCDC.
After it runs a ...
Id #10788 | Release:
| Updated: Feb 21, 2013 at 11:28 PM by SalvatoreC | Created: May 22, 2012 at 9:37 AM by SalvatoreC
We are facing a strange issue with kimball component while inserting scd1 & scd2 changes. The problem that we are facing is when we run the package with SCD1 changes then kimball ...
Id #10775 | Release:
| Updated: Feb 21, 2013 at 11:28 PM by swapniljadhav | Created: May 18, 2012 at 5:11 AM by swapniljadhav
We have just begun to test your component with a number of large data syncronisation tasks we currently perform via various combersome (and slow) methods. We have seen how good the component is, as...
Id #10771 | Release:
| Updated: Mar 27, 2013 at 11:37 AM by JesusLopezRuiz | Created: May 17, 2012 at 10:06 AM by jacobsmc
I'm looking for the SQL Server 2012 SSIS Dimension Merge SCD Component.
Thanks in advance for any help.
Id #10604 | Release:
| Updated: Nov 4, 2013 at 7:40 PM by vinay459 | Created: Apr 3, 2012 at 10:54 AM by DenisFR