Problemas importar en sql'05 y tambien en ssis
Publicado por kinetic_brain (7 intervenciones) el 11/02/2011 02:50:03
Estimados:
desde que empece a usar sql 2005 siempre se queja al importar datos txt, lo probe en BI con ssis ( y tambien.
Hay algo que estoy haciendo mal, porque con sql 2000 no tengo estos problemas es campion para importar y exportar.
Ahora quiero importar desde un archivo txt archivo liviano con 12 columnas separados por pipe. este es el error en BI:
[DTS.Pipeline] Information: Validation phase is beginning.
Progress: Validating - 0 percent complete
Progress: Validating - 50 percent complete
Progress: Validating - 100 percent complete
[DTS.Pipeline] Information: Prepare for Execute phase is beginning.
Progress: Prepare for Execute - 0 percent complete
Progress: Prepare for Execute - 50 percent complete
Progress: Prepare for Execute - 100 percent complete
[DTS.Pipeline] Information: Pre-Execute phase is beginning.
Progress: Pre-Execute - 0 percent complete
[carga lci [1]] Information: The processing of file "F:\Lista.txt" has started.
Progress: Pre-Execute - 50 percent complete
[SQL Server Destination [54]] Error: The thread for the SSIS Bulk Insert task failed initialization.
[DTS.Pipeline] Error: component "SQL Server Destination" (54) failed the pre-execute phase and returned error code 0xC020203B.
Progress: Pre-Execute - 100 percent complete
[DTS.Pipeline] Information: Post Execute phase is beginning.
Progress: Post Execute - 0 percent complete
[carga lci [1]] Information: The processing of file "F:\Lista.txt" has ended.
Progress: Post Execute - 50 percent complete
[DTS.Pipeline] Information: Cleanup phase is beginning.
Progress: Cleanup - 0 percent complete
Progress: Cleanup - 50 percent complete
Progress: Cleanup - 100 percent complete
[DTS.Pipeline] Information: "component "SQL Server Destination" (54)" wrote 0 rows.
Task Data Flow Task failed
Finished, 21:50:29, Elapsed time: 00:00:00.110
Validation is completed
Start, 21:50:29
Warning: The Execution method succeeded, but the number of errors raised (2) 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.
Finished, 21:50:29, Elapsed time: 00:00:00.140.
y importando en sql server 2005
el error es :
Executing (Error)
Messages
Error 0xc02020a1: Data Flow Task: Data conversion failed. The data conversion for column "Comentario" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
(SQL Server Import and Export Wizard)
Error 0xc020902a: Data Flow Task: The "output column "Comentario" (28)" failed because truncation occurred, and the truncation row disposition on "output column "Comentario" (28)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
(SQL Server Import and Export Wizard)
Error 0xc0202092: Data Flow Task: An error occurred while processing file "F:\Lista.txt" on data row 19.
(SQL Server Import and Export Wizard)
Error 0xc0047038: Data Flow Task: The PrimeOutput method on component "Source - Lista.txt" (1) returned error code 0xC0202092. 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.
(SQL Server Import and Export Wizard)
Error 0xc0047021: Data Flow Task: Thread "SourceThread0" has exited with error code 0xC0047038.
(SQL Server Import and Export Wizard)
Error 0xc0047039: Data Flow Task: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.
(SQL Server Import and Export Wizard)
Error 0xc0047021: Data Flow Task: Thread "WorkThread0" has exited with error code 0xC0047039.
(SQL Server Import and Export Wizard)
como debo importar correctamente?, debo formatiar o ignorar algun parametro, por favor ayuda, creo que de 10 tablas que he intentado importar solo una se importo bien.
desde que empece a usar sql 2005 siempre se queja al importar datos txt, lo probe en BI con ssis ( y tambien.
Hay algo que estoy haciendo mal, porque con sql 2000 no tengo estos problemas es campion para importar y exportar.
Ahora quiero importar desde un archivo txt archivo liviano con 12 columnas separados por pipe. este es el error en BI:
[DTS.Pipeline] Information: Validation phase is beginning.
Progress: Validating - 0 percent complete
Progress: Validating - 50 percent complete
Progress: Validating - 100 percent complete
[DTS.Pipeline] Information: Prepare for Execute phase is beginning.
Progress: Prepare for Execute - 0 percent complete
Progress: Prepare for Execute - 50 percent complete
Progress: Prepare for Execute - 100 percent complete
[DTS.Pipeline] Information: Pre-Execute phase is beginning.
Progress: Pre-Execute - 0 percent complete
[carga lci [1]] Information: The processing of file "F:\Lista.txt" has started.
Progress: Pre-Execute - 50 percent complete
[SQL Server Destination [54]] Error: The thread for the SSIS Bulk Insert task failed initialization.
[DTS.Pipeline] Error: component "SQL Server Destination" (54) failed the pre-execute phase and returned error code 0xC020203B.
Progress: Pre-Execute - 100 percent complete
[DTS.Pipeline] Information: Post Execute phase is beginning.
Progress: Post Execute - 0 percent complete
[carga lci [1]] Information: The processing of file "F:\Lista.txt" has ended.
Progress: Post Execute - 50 percent complete
[DTS.Pipeline] Information: Cleanup phase is beginning.
Progress: Cleanup - 0 percent complete
Progress: Cleanup - 50 percent complete
Progress: Cleanup - 100 percent complete
[DTS.Pipeline] Information: "component "SQL Server Destination" (54)" wrote 0 rows.
Task Data Flow Task failed
Finished, 21:50:29, Elapsed time: 00:00:00.110
Validation is completed
Start, 21:50:29
Warning: The Execution method succeeded, but the number of errors raised (2) 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.
Finished, 21:50:29, Elapsed time: 00:00:00.140.
y importando en sql server 2005
el error es :
Executing (Error)
Messages
Error 0xc02020a1: Data Flow Task: Data conversion failed. The data conversion for column "Comentario" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
(SQL Server Import and Export Wizard)
Error 0xc020902a: Data Flow Task: The "output column "Comentario" (28)" failed because truncation occurred, and the truncation row disposition on "output column "Comentario" (28)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
(SQL Server Import and Export Wizard)
Error 0xc0202092: Data Flow Task: An error occurred while processing file "F:\Lista.txt" on data row 19.
(SQL Server Import and Export Wizard)
Error 0xc0047038: Data Flow Task: The PrimeOutput method on component "Source - Lista.txt" (1) returned error code 0xC0202092. 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.
(SQL Server Import and Export Wizard)
Error 0xc0047021: Data Flow Task: Thread "SourceThread0" has exited with error code 0xC0047038.
(SQL Server Import and Export Wizard)
Error 0xc0047039: Data Flow Task: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.
(SQL Server Import and Export Wizard)
Error 0xc0047021: Data Flow Task: Thread "WorkThread0" has exited with error code 0xC0047039.
(SQL Server Import and Export Wizard)
como debo importar correctamente?, debo formatiar o ignorar algun parametro, por favor ayuda, creo que de 10 tablas que he intentado importar solo una se importo bien.
Valora esta pregunta
0
