SCD CurrentRecord trouble

Topics: Issues 2: Using the Component (Design-Time)
Feb 9, 2011 at 5:31 AM

I can't make the CurrentRecord in the SCD v1.5 transformation work (even though I associated the CurrentRecord item to my CurrentRecord field in my database).  Even when I pre-populate the CurrentRecord field with a 1, the transformation always just completely disregards the field (new entries by the SCD have a NULL value in the field.. and expired entries continue to show a 1 instead of being changed to a 0).  Since there is no Boolean data type in SQL Server 2008, I used bit.  But still no go..   Any idea what I might be doing wrong?  Thanks so much. 

Feb 22, 2011 at 10:01 PM

Start placing Data Viewers on the inputs and outputs of the component.  When SSIS reads BIT data from SQL Server, I believe it converts it to a DT_BOOL - but I can't recall for certain.  The component should then properly process the boolean value, but you then need to make sure that you're persisting that boolean back to your database properly by converting it explicitly or implicitly to a type SQL Server understands.