November 5, 2010 at 9:16 am
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
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy