October 3, 2008 at 9:02 am
I have a pretty simple SSIS package. When I try to execute it indicates that it has encountered errors.
In order to get them I go to Execution Results tab, right? But the problem is that description of an error is so long that it does not fit the width of my screen.
When I move mouse over the description line it displays whole description in a "tool-tip", however only for few seconds. Moving mouse up and down does not let me concentrate on the message text. Besides, there many error lines there.
Is there another way to retrieve all errors in a text file, like an eror log?
Thanks
October 3, 2008 at 2:05 pm
October 9, 2008 at 12:18 pm
Simple answer: Right-click the error line in the Execution Results tab, click "Copy Error Message Text" (or something like that) and paste it into Notepad.
Slightly less simple answer: Turn on package logging by clicking SSIS...Package Logging in Visual Studio and log your errors to a file or database table.
Option one is generally fine for development (albeit a pain sometimes). You'll want option two once you go to production anyway.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply