I have designed a packge using SSIS 2008 and populated 100 records first day it was worked fine.
Secound there 100 old records(some records are changed ) and 5000 new records and started load the data. When i start the package i am getting the below error.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Slowly Changing Dimension" (1354) failed with error code 0xC0202009 while processing input "Slowly Changing Dimension Input" (1365). The identified
component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the
View Complete Post