none
Error al ejecutar un proceso ETl

    Pregunta

  • Buenas tardes 

     Hace poco empece a utilizar la herramienta SSDT para crear los procesos de ETL, este projecto es el primero que hago . 

    al ejecutarlo,  el workflow queda con los "check" en verde, pero me no me inserta ningun dato en la tabla,

    Lo que hace este proceso basicamente es normalizar un excel, me pasan el excel y yo lo paso por el proceso para normalizar los numeros de telefono y que me deuvleva otro excel con los datos correctos , para poder realizar la carga de estos datos en la base de datos, mediante una plataforma web(CRM).

    Solo ejecute el "data flow task", que uso una coneccion excel source y una OLEDB destination, basicamente primero inserto el excel en una tabla para luego extraer esos datos y aplicarles los Fix Data para la normalizacion. 

    Al ejecutar el dataflowtask no me inserta nada en la tabla y esto es lo que me figura en el debugger

    "

    Warning: 0x80049304 at Data Flow Task, SSIS.Pipeline: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available.  To resolve, run this package as an administrator, or on the system's console.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "cliente" (12) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "dni" (13) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "cp" (14) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "localidad" (15) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "fecha_nac" (16) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "estado_civ" (17) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "TEL_CEL" (18) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "CEL" (19) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "MAIL" (20) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "Nissan_0km" (21) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "Volskwagen_0km" (22) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning.
    Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning.
    Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning.
    Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning.
    Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "OLE DB Destination" wrote 0 rows.
    Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning.
    SSIS package "C:\Users\it-wstefani\Documents\Visual Studio 2015\Projects\EtlNeotel_emma\Integration Services Project2\Mapfre_autos (1).dtsx" finished: Success. "

    domingo, 28 de enero de 2018 17:55

Respuestas

  • lo que te esta´diciendo es que no se puede usar y que no tienes conecatdas un montón de columnas en el data flow, ¿se te ponen los numeritos? da la sensación de que no inserta porque no está leyendo nada. 

    Comparte lo que sepas, aprende lo que no sepas (FGG)
    portalSQL
    El rincón del DBA

    lunes, 29 de enero de 2018 9:20
    Moderador

Todas las respuestas

  • Hola

    al parecer se trata de un tema de permisos. Te sugiero abrir el sql data tools como administrador "run as administrator" y ejecutar tu flujo.

    Saludos


    Brayan De la Cruz
    Lima - Perú


    domingo, 28 de enero de 2018 18:02
  • Brayan

     Gracias por responder, si lo lo ejecute como administrador y lo mismo, solo que la primer parte del error no me aparece

    "

    SSIS package "C:\Users\it-wstefani\Documents\Visual Studio 2015\Projects\EtlNeotel_emma\Integration Services Project2\Mapfre_autos (1).dtsx" starting.
    Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "cliente" (12) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "dni" (13) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "cp" (14) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "localidad" (15) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "fecha_nac" (16) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "estado_civ" (17) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "TEL_CEL" (18) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "CEL" (19) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "MAIL" (20) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "Nissan_0km" (21) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "Volskwagen_0km" (22) on output "Excel Source Output" (11) and component "Excel Source" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning.
    Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning.
    Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning.
    Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning.
    Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "OLE DB Destination" wrote 0 rows.
    Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning.
    SSIS package "C:\Users\it-wstefani\Documents\Visual Studio 2015\Projects\EtlNeotel_emma\Integration Services Project2\Mapfre_autos (1).dtsx" finished: Success."
    domingo, 28 de enero de 2018 20:15
  • lo que te esta´diciendo es que no se puede usar y que no tienes conecatdas un montón de columnas en el data flow, ¿se te ponen los numeritos? da la sensación de que no inserta porque no está leyendo nada. 

    Comparte lo que sepas, aprende lo que no sepas (FGG)
    portalSQL
    El rincón del DBA

    lunes, 29 de enero de 2018 9:20
    Moderador
  • Estimados, esta solucionado , ya pude insertar registros en la tabla y extraer los mismo, pero la parte de extraccion solo funciona , si ejecuto las tareas por parte. 

    Osea si ejecuto el paquete completo, lo que esta dentro del "For Each" , no lo ejecuta, y ahi adentro tengo la extracion de datos. Dentro del for eahc tengo un system task y un data flow task.

    Como lo solucione: Tania otros procesos, creados por mi jefe y otro compañer, lo que hice fue cortar y pegar los data flow, mirandolo detenidamente, me faltaban las columnas en "+ODBC -Output Columns".  

    lunes, 29 de enero de 2018 19:43