Post reply

Debugging Script component

  • February 6, 2009 at 4:05 pm

    #128662

    Hello all,

    I just wanted to say kudos to those people that had to endure programming when the debuggers of today didn't exist. I'm not sure I'd be a programmer if I had to try and figure out where errors without one! It is a pain in the *** trying to debug the SSIS's script component data flow task without a debugger.

    My way of debugging is basically copying my code from SSIS into VB.NET and translating SSIS objects to a VB.NET equivalent and debugging that way. Its a pain to have to do this because I literally have try to simulate exactly what SSIS is doing in the script component.

    If anyone has a better way of debugging their script components, I'd love to hear about it!

    Thanks,

    Strick

  • February 6, 2009 at 7:39 pm

    #939882

    I do this all the time - just set a breakpoint where you want to start debugging and then run it ...

    Phil

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • February 7, 2009 at 8:33 am

    #939979

    Hello,

    I think you are referring to the script task not script component. The script task (control flow item) lets you debug. The script component (data flow item) does not.

    Thanks

  • February 7, 2009 at 9:02 am

    #939990

    stricknyn (2/6/2009)

    Hello all,

    I just wanted to say kudos to those people that had to endure programming when the debuggers of today didn't exist. I'm not sure I'd be a programmer if I had to try and figure out where errors without one! It is a pain in the *** trying to debug the SSIS's script component data flow task without a debugger.

    My way of debugging is basically copying my code from SSIS into VB.NET and translating SSIS objects to a VB.NET equivalent and debugging that way. Its a pain to have to do this because I literally have try to simulate exactly what SSIS is doing in the script component.

    If anyone has a better way of debugging their script components, I'd love to hear about it!

    Thanks,

    Strick

    You have these options available:

    - use data viewers between components to check the result of the transformation.

    - use message boxes.

    - use logging to the console or windows events or any other type of logging you can come up.

    I'm sorry to say there is no debug support available like in script task. This is major limitation, which is still not address even in SQL 2008.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • February 7, 2009 at 2:01 pm

    #940060

    stricknyn (2/7/2009)

    Hello,

    I think you are referring to the script task not script component. The script task (control flow item) lets you debug. The script component (data flow item) does not.

    Thanks

    🙂 indeed. I thought that one was a bit too easy to answer!

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply