3
Vote

Unable to initialize SCD2 Date Handling

description

After I configured the component and ran the package, I get the following error thrown by the package - I am not using SCD2, which I correctly set as not being used...
System.Exception: Unable to initialize SCD2 Date Handling. at MouldingAndMillwork.SSIS.DimensionMergeSCDConfiguration.SCD2DateHandler.PreExecute(IDTSVariableDispenser100 variableDispenser) at MouldingAndMillwork.SSIS.DimensionMergeSCD.PreExecute() at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)
 
component "Dimension Merge Slowly Changing Dimension" (3074) failed the pre-execute phase and returned error code 0x80131500.

comments

nte wrote May 5, 2011 at 7:47 PM

I had the same problem. Any ideas how to fix it?

nte wrote May 6, 2011 at 2:39 PM

I figured it out.

On the SCD 2 Date Handling tab the [variable containing "now" value] drop-down was empty. I selected 'System::StartTime' and the task runs perfectly. Even though I'm not using any SCD 2 fields, this drop-down needs a value.

freedom_nut wrote Mar 5, 2012 at 10:06 PM

Thanks for this solution! Worked fantastically...now I can go home!

Sign in to add a comment or to set email notifications