Post reply

execution package

  • August 29, 2006 at 6:17 am

    #153157

    Hi,

     When running packages you get the logging within the execution result tab. Does anyone know of a way to export this text. I can only copy one line at a time, and the users would like the whole text, for their testing.

     

     Thanks

     Alan

  • September 1, 2006 at 7:13 am

    #658018

    When in design mode, choose "View Output" - this will give you an output window.  When execution is done, this will contain all your execution info (it is actually easier to find errors in this list) which you can Ctrl-A Ctrl-C to copy it out.  Right-click for more options to make it more User-friendly.

    Alternatively, you can get detailed logging into a text file: when in design mode, go to SSIS - Logging on the menu.  Create a new provider e.g. a text file on a share or wherever, then go to details to choose which events to monitor.  I would suggest initially going for all of them, but click on "Advanced" and deselect the Computer, Operator and definitely the SourceID and ExecutionID (horrible GUIDs).

    Then try it out & whittle down the list of items e.g. OnInformation is probably a winner, OnPreValidate not so helpful.

    This produces a CSV which is not that shiny but hey - another SSIS package later & you can have it in a workbook, e-mailed to the users' desks!  It is probably better suited to serious debugging.

    HTH,

    Matt

     

     

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

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