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:
None
| Updated: Mar 29 at 10:28 AM by SushantA | Created: Mar 29 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:
None
| Updated: Feb 21 at 11:28 PM by amostay | Created: Jan 30 at 4:28 AM by amostay
Hi,
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:
None
| Updated: Feb 21 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:
None
| Updated: Feb 21 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:
None
| Updated: Feb 21 at 11:28 PM by SalvatoreC | Created: May 22, 2012 at 9:37 AM by SalvatoreC
Hi Everyone,
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:
None
| Updated: Feb 21 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:
None
| Updated: Mar 27 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:
None
| Updated: Apr 26 at 3:21 AM by MikeHoney | Created: Apr 3, 2012 at 10:54 AM by DenisFR
We have six packages that all have SCDC controls running in parallel they create duplicate row(s) in dimension tables, When i create a unique index on the Business Key columns the SCDC control fail...
Id #10368 | Release:
None
| Updated: Feb 21 at 11:28 PM by KBLarsen | Created: Feb 13, 2012 at 1:56 PM by chandrasc
I'm havine an issue with the SCD2. I have a dimensions where I want to use SCD2 for any attribute field that changes. In the set up I've identified a surrogate key, business key, SCD2 Effective Dat...
Id #10242 | Release:
None
| Updated: Feb 21 at 11:28 PM by KBLarsen | Created: Jan 26, 2012 at 7:30 PM by gbuschmann