Ajuda com Integration Services
28/07/2012
0
Olá,
Eu tenho 3 bases de dados 1 planilha do Excel uma base em Acces e uma base do SQL Server.
Eu quero fazer um ETL dessas 3 bases e mover seu conteúdo para uma base multidimensional para assim criar um cubo, acontece que não consigo enviar os dados de cada uma dessas bases para a base multidimensional pelo Integration Service, estou tentando carregar a informação de cada coluna nas tabelas dimensões mas algumas pessoas que pedi ajuda me disseram que não pode carregar direto nas dimensões deve carregar a fato mas fiquei confuso já que a tabela fato vai ter informações cruzadas das dimensões. Podem me ajudar?
Eu tenho 3 bases de dados 1 planilha do Excel uma base em Acces e uma base do SQL Server.
Eu quero fazer um ETL dessas 3 bases e mover seu conteúdo para uma base multidimensional para assim criar um cubo, acontece que não consigo enviar os dados de cada uma dessas bases para a base multidimensional pelo Integration Service, estou tentando carregar a informação de cada coluna nas tabelas dimensões mas algumas pessoas que pedi ajuda me disseram que não pode carregar direto nas dimensões deve carregar a fato mas fiquei confuso já que a tabela fato vai ter informações cruzadas das dimensões. Podem me ajudar?
Jônatas Oliveira
Curtir tópico
+ 0
Responder
Posts
07/08/2012
Roniere Almeida
só serve se for com o Integration Services? bom nunca trabalhei com essa parte, mas fiz um artigo, bem passo a passo, criando um cubo utilizando o Analysis Services, espero que possa te ajudar.
https://www.devmedia.com.br/criando-um-cubo-no-analysis-services/25302
https://www.devmedia.com.br/criando-um-cubo-no-analysis-services/25302
Responder
18/08/2012
Jônatas Oliveira
Eu preciso preparar o DW e o Analisys Services não faz isso :/
Responder
18/08/2012
Jônatas Oliveira
Consegui criar toda a estrutura com o tutorial em https://www.devmedia.com.br/artigo-sql-magazine-59-implementando-uma-solucao-business-intelligence-com-o-microsoft-sql-server-2005-parte-1/11077 mas tenho um problema eu não consegui usar a task que ele passou para não duplicar a tabela fato alguém pode me ajudar?
Obrigado desde já
Obrigado desde já
Responder
25/08/2012
Jônatas Oliveira
Esta dando o seguinte erro no meu Integration Services
Error: 0xC020901E at DFT Incidentes, LKP dim_Atendente [1027]: Row yielded no match during lookup.
Error: 0xC0209029 at DFT Incidentes, LKP dim_Atendente [1027]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "LKP dim_Atendente" (1027)" failed because error code 0xC020901E occurred, and the error row disposition on "output "Lookup Match Output" (1029)" 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 DFT Incidentes, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "LKP dim_Atendente" (1027) failed with error code 0xC0209029 while processing input "Lookup Input" (1028). 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.
Error: 0xC02020C4 at DFT Incidentes, Excel Source [868]: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
Error: 0xC0047038 at DFT Incidentes, SSIS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Excel Source" (868) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
Information: 0x40043008 at DFT Incidentes, SSIS.Pipeline: Post Execute phase is beginning.
Information: 0x4004300B at DFT Incidentes, SSIS.Pipeline: "component "ADO NET FATO_INCIDENTES" (1127)" wrote 0 rows.
Information: 0x40043009 at DFT Incidentes, SSIS.Pipeline: Cleanup phase is beginning.
Task failed: DFT Incidentes
Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (5) 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 "Package.dtsx" finished: Failure.
Error: 0xC020901E at DFT Incidentes, LKP dim_Atendente [1027]: Row yielded no match during lookup.
Error: 0xC0209029 at DFT Incidentes, LKP dim_Atendente [1027]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "LKP dim_Atendente" (1027)" failed because error code 0xC020901E occurred, and the error row disposition on "output "Lookup Match Output" (1029)" 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 DFT Incidentes, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "LKP dim_Atendente" (1027) failed with error code 0xC0209029 while processing input "Lookup Input" (1028). 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.
Error: 0xC02020C4 at DFT Incidentes, Excel Source [868]: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
Error: 0xC0047038 at DFT Incidentes, SSIS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Excel Source" (868) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
Information: 0x40043008 at DFT Incidentes, SSIS.Pipeline: Post Execute phase is beginning.
Information: 0x4004300B at DFT Incidentes, SSIS.Pipeline: "component "ADO NET FATO_INCIDENTES" (1127)" wrote 0 rows.
Information: 0x40043009 at DFT Incidentes, SSIS.Pipeline: Cleanup phase is beginning.
Task failed: DFT Incidentes
Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (5) 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 "Package.dtsx" finished: Failure.
Responder
25/08/2012
Jônatas Oliveira
Pelo que eu vi há um problema com os formatos que estão no excel com os formatos determinados, por exemplo no meu excel tenho um campo codigo que mostra valores com zeros as esquerda ex: 004 mas quando vai pro Integration Services aparece 4, ai quando mudei os dados para uma base de dados sql server e ai ele foi, agora está acontecendo algo estranho, estou fazendo um lookup de 2 nvarchar(20) mas ele retorna os erros abaixo.
Error: 0xC020901E at DFT Incidentes, LKP Dim_Produto [1065]: Row yielded no match during lookup.
Error: 0xC0209029 at DFT Incidentes, LKP Dim_Produto [1065]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.
The "component "LKP Dim_Produto" (1065)" failed because error code 0xC020901E occurred, and the error row disposition on "output "Lookup Match Output" (1067)"
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 DFT Incidentes, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED.
The ProcessInput method on component "LKP Dim_Produto" (1065) failed with error code 0xC0209029 while processing input "Lookup Input" (1066).
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.
Error: 0xC02090F5 at DFT Incidentes, ADO NET Source [1410]: The component "ADO NET Source" (1410) was unable to process the data. Exceção de HRESULT: 0xC0047020
Error: 0xC0047038 at DFT Incidentes, SSIS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.
The PrimeOutput method on component "ADO NET Source" (1410) returned error code 0xC02090F5.
The component returned a failure code when the pipeline engine called PrimeOutput().
The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
There may be error messages posted before this with more information about the failure.
Alguem pode me ajudar?
Error: 0xC020901E at DFT Incidentes, LKP Dim_Produto [1065]: Row yielded no match during lookup.
Error: 0xC0209029 at DFT Incidentes, LKP Dim_Produto [1065]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.
The "component "LKP Dim_Produto" (1065)" failed because error code 0xC020901E occurred, and the error row disposition on "output "Lookup Match Output" (1067)"
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 DFT Incidentes, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED.
The ProcessInput method on component "LKP Dim_Produto" (1065) failed with error code 0xC0209029 while processing input "Lookup Input" (1066).
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.
Error: 0xC02090F5 at DFT Incidentes, ADO NET Source [1410]: The component "ADO NET Source" (1410) was unable to process the data. Exceção de HRESULT: 0xC0047020
Error: 0xC0047038 at DFT Incidentes, SSIS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.
The PrimeOutput method on component "ADO NET Source" (1410) returned error code 0xC02090F5.
The component returned a failure code when the pipeline engine called PrimeOutput().
The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
There may be error messages posted before this with more information about the failure.
Alguem pode me ajudar?
Responder
Clique aqui para fazer login e interagir na Comunidade :)
