Vi que tem muita dificuldade para esta carga, não consegui identificar o meu erro nos demais fóruns. Segue erro:
Error: 0xC0209029 at Carga Fato 001, Insert Destination [178]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "Insert Destination.Entradas[Entrada de Destino OLE DB]" failed because error code 0xC020907B occurred, and the error row disposition on "Insert Destination.Entradas[Entrada de Destino OLE DB]" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. Error: 0xC0047022 at Carga Fato 001, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Insert Destination" (178) failed with error code 0xC0209029 while processing input "Entrada de Destino OLE DB" (191). 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 failure. Information: 0x40043008 at Carga Fato 001, SSIS.Pipeline: Post Execute phase is beginning. Information: 0x4004300B at Carga Fato 001, SSIS.Pipeline: "Insert Destination" wrote 0 rows. Information: 0x40043009 at Carga Fato 001, SSIS.Pipeline: Cleanup phase is beginning. Task failed: Carga Fato 001 Warning: 0x80019002 at Carga Fato: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. SSIS package "C:\Users\55849\Desktop\Arquivos - Aula 2\Projetos\DatawareHouseSucos\CargaDataWarehouse\Carga Fato.dtsx" finished: Failure. The program '[8736] DtsDebugHost.exe: DTS' has exited with code 0 (0x0).
