Olá Boa tarde. Alguém conseguiria me ajudar? Ao executar a CargaDatawarehouse.dtsx o meu processo acusou erro nas Fatos:
Exemplo:
Warning: 0x80047076 at Carga Fato003, SSIS.Pipeline: The output column "DATA_FATO" (14) on output "Saída de Origem OLE DB" (13) and component "Carga Fato 003" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Information: 0x40043006 at Carga Fato003, SSIS.Pipeline: Prepare for Execute phase is beginning.
Warning: 0x80047076 at Carga Fato002, SSIS.Pipeline: The output column "DATA_FATO" (14) on output "Saída de Origem OLE DB" (13) and component "Carga Fato 002" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Information: 0x40043006 at Carga Fato002, SSIS.Pipeline: Prepare for Execute phase is beginning.
Warning: 0x80047076 at Carga Fato001, SSIS.Pipeline: The output column "DATA_FATO" (14) on output "Saída de Origem OLE DB" (13) and component "Carga Fato 001" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Information: 0x40043006 at Carga Fato001, SSIS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Carga Fato003, SSIS.Pipeline: Pre-Execute phase is beginning.
Information: 0x40043007 at Carga Fato002, SSIS.Pipeline: Pre-Execute phase is beginning.
Information: 0x40043007 at Carga Fato001, SSIS.Pipeline: Pre-Execute phase is beginning.
Information: 0x4004300C at Carga Fato003, SSIS.Pipeline: Execute phase is beginning.
Information: 0x4004300C at Carga Fato002, SSIS.Pipeline: Execute phase is beginning.
Information: 0x4004300C at Carga Fato001, SSIS.Pipeline: Execute phase is beginning.
Error: 0xC0202009 at Carga Fato003, Insert Destination 1 [94]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E2F.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E2F Description: "A instrução foi finalizada.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E2F Description: "A instrução INSERT conflitou com a restrição do FOREIGN KEY "FK_Fato_003_Dim_Tempo". O conflito ocorreu no banco de dados "DW_SUCOS", tabela "dbo.Dim_Tempo", column 'Cod_Dia'.".
Error: 0xC0209029 at Carga Fato003, Insert Destination 1 [94]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "Insert Destination 1.Entradas[Entrada de Destino OLE DB]" failed because error code 0xC020907B occurred, and the error row disposition on "Insert Destination 1.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 Fato003, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Insert Destination 1" (94) failed with error code 0xC0209029 while processing input "Entrada de Destino OLE DB" (107). 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 Fato003, SSIS.Pipeline: Post Execute phase is beginning.
Information: 0x4004300B at Carga Fato003, SSIS.Pipeline: "Insert Destination 1" wrote 0 rows.
Information: 0x40043009 at Carga Fato003, SSIS.Pipeline: Cleanup phase is beginning.
Task failed: Carga Fato003
