Debugging SSIS package using dtexec console and console.writeline.

• Ronnie-651316

  SSC-Addicted

  Points: 434

  More actions

  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

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  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

• alex.myles

  SSC Enthusiast

  Points: 185

  More actions

  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