Post reply

Debugging SSIS package using dtexec console and console.writeline.

  • October 11, 2013 at 6:49 am

    #150514

    Hi,

    I have a silly issue when trying to debug SSIS package.

    When I run the package via dtexec and capture the output via a redirect the output in the file is out of order.

    If I run the command as

    dtexec /f package.dtsx

    The output on the screen is correct:

    step 1

    step 2

    step 3

    output of console.writeline1

    step 4

    output of console.writeline2

    step 5

    when I do it with a redirect:

    dtexec /f package.dtsx > test.log

    the output in test.log would be

    output of console.writeline1

    output of console.writeline2

    step 1

    step 2

    step 3

    step 4

    step 5

    Anyone seen this before as it makes debugging the package difficult.

    Thanks

    Ronnie

  • October 11, 2013 at 6:59 am

    #1657887

    I never debug this way, so I haven't seen it of course. 🙂

    Why don't you debug in Visual Studio?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • November 17, 2014 at 9:38 am

    #1759024

    I've got this issue as well - it's very annoying. Our SSIS task is part of a batch file that does some other stuff too so sometimes we need to test outside of Visual Studio. This bug/issue makes the console output pretty worthless

Viewing 3 posts - 1 through 3 (of 3 total)

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