Post reply

Save execution results - how?

  • November 5, 2010 at 9:16 am

    #143972

    I've created a package with 7 containers with 3 to 5 control flow items each. When I run a test in SSIS (SQL Server 2005 9.00.4035 - all service packs) some useful messages, errors and warnings, are left in the execution results. Individual lines can be saved by right-clicking on it and selecting "Copy Message Text".

    How can I cave the whole stream of messages?

    Thank you for any assistance.

  • November 5, 2010 at 9:50 am

    #1247202

    Look into adding logging to your packages. Google it...there are a ton of resources out there to do this. You should be able to get exactly what you need.

  • June 21, 2013 at 8:32 am

    #1626347

    Click on the "View" tab and select "Output" in BIDS. This will show you the execution result/progress in the output window below. Once done you can select all the rows/lines that you want and paste them into a text file and save for future reference.

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

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