Filter/Ignore certain SSIS warnings in log file.

Posted on 2011-10-25
Last Modified: 2012-06-27
I have an SSIS package which runs as I expect but generates a repeated warning in the log file. I know all warnings should be resolved in the first place, but in this case the warning is expected and I just dont want to see it as part of my logfile. Is there a way to filter or set ignore rules on the specific types of errors that are being generated
Question by:Blowfelt82
    LVL 24

    Expert Comment

    MySQL != MS-SQL.  Better click "Request Attention" and have the zones changed.
    LVL 37

    Expert Comment

    You could switch off all warnings for that package.  This can be done by opening up the log config screen (right-click yellow background in Control Flow and select Logging).  In the Details tab, remove the checkbox next to the OnWarning event.

    Author Comment

    I dont want to go down the route of switching off all warnings incase I do actually get some. I would prefer to be able to specify that a certain error is ignored?
    LVL 37

    Accepted Solution

    I don't think that will be possible without writing any custom logging.  Another option that you may have is to log to a table instead of a file, if that would work in your situation?  In that case you can just filter them out using the WHERE clause.
    LVL 100

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now