This project is read-only.

Has anyone managed to use this with VS2015?

I've installed the component, but in VS2015 there is no way to explicitly add items to the SSIS Toolbox. Instead, you just get a right-click "Refresh Toolbox" menu item, which doesn't make the com...

Id #14008 | Release: None | Updated: Nov 18, 2016 at 9:49 AM by SebT27 | Created: Nov 8, 2016 at 11:22 AM by SebT27

Double records in dimension

I've created a new dimension using the SCD component. I've noticed that the second incremental load causes double records in my dimension, with the same business key. When I activate all logging, i...

Id #13667 | Release: None | Updated: Aug 6, 2015 at 10:18 AM by SCDUser | Created: Aug 6, 2015 at 10:18 AM by SCDUser

SQL Server 2014 update ?

Hello Everyone, Do we have the code or installation files to install this component for SQL Server 2014. We are moving from SQL Server 2008 R2 to SQL Server 2014. So even an upgrade utility/plan ...

Id #13618 | Release: None | Updated: Dec 23, 2015 at 3:16 PM by thijs_nijhuis | Created: Jun 8, 2015 at 8:24 PM by rightesh

Error: 'New' output needs column metadata updated (lineage).

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: None | Updated: May 22, 2014 at 1:31 PM by beppy | Created: Dec 10, 2013 at 4:54 PM by vinay459

System.OutOfMemoryException with 50M source rows, 0 existing rows

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: None | Updated: Oct 24, 2013 at 10:01 AM by hbeomadadk | Created: Oct 24, 2013 at 10:01 AM by hbeomadadk

Row deleted from source is identified but not redirected to Deleted output

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, 2013 at 11:28 AM by SushantA | Created: Mar 29, 2013 at 10:55 AM by SushantA

Error: Internal error (Column data type DT_DBTIME2 is not supported by the PipelineBuffer class.) in ProcessInput sending row to cache.

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 29, 2016 at 1:11 PM by n0meX | Created: Jan 30, 2013 at 5:28 AM by amostay

invalid input

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 22, 2013 at 12:28 AM by edwinbrinza | Created: Aug 1, 2012 at 2:09 PM by edwinbrinza

multiple current record for same business key

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 22, 2013 at 12:28 AM by MrTintin | Created: Jul 4, 2012 at 4:39 PM by pilab72

Existing members in Dim Table are inserted again

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 22, 2013 at 12:28 AM by SalvatoreC | Created: May 22, 2012 at 10:37 AM by SalvatoreC