Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 536
  • Last Modified:

Filter/Ignore certain SSIS warnings in log file.

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
0
Blowfelt82
Asked:
Blowfelt82
1 Solution
 
johanntagleCommented:
MySQL != MS-SQL.  Better click "Request Attention" and have the zones changed.
0
 
ValentinoVBI ConsultantCommented:
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.
0
 
Blowfelt82Author Commented:
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?
0
 
ValentinoVBI ConsultantCommented:
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.
0
 
mlmccCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now