Post reply

Need to pipe DTEXEC output to a file

  • April 8, 2009 at 7:34 am

    #208233

    I've created a simple bat file called RunMySSIS.bat --- it contains the following single instruction:

    dtexec /File \\MyServer\MyDirectory\MySSIS_Pkg.dtsx

    The package MySSIS_Pkg runs successfully (initiating 25 sub pkg's etc...)

    HOW CAN I set up this command to pipe the output into an OUTPUT file for later review?

    (OSQL uses a /O parameter --- I'm looking for a similar command for DTEXEC)

    thx in advance

    BT

  • April 8, 2009 at 7:54 am

    #974295

    You could try a capture at the OS level by appending a redirect on the command line in the batch file:

    dtexec /File \\MyServer\MyDirectory\MySSIS_Pkg.dtsx > somelogfile.log

  • April 8, 2009 at 10:19 am

    #974485

    tried that.. didn't work.. any other idea's for capturing a DTEXEC output which is run in DOS

    BT

  • April 8, 2009 at 10:40 am

    #974509

    actually -- got it to work -- thanks for the solution..

    BT

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

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