SSIS start/finish logging into Application log

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

eXavier - 03 Mar 2008 16:56 GMT

Hello,
We use SSIS packages (dtsx) for databases synchronization. The packages are
executed periodically every 2 minutes and run well. The problem is that
Windows Application event log gets overfull with informational messages about
starting and finishing packages. (The main package uses configuration to
execute other packages, so there is about 10 packages executed every 2
minutes.) This huge logging makes the Application log almost useless. I found
that this is feature-by-design, however I would need to solve this issue as
this behavior is not acceptable for our customer's production environment.
Can I redirect the messages into different log? Any idea how to get rid of
this information messages?

Thanks,
eXavier

Reply to this Message

Charles Wang[MSFT] - 04 Mar 2008 06:54 GMT

Hi eXavier,
I reproduce your issue. From my research, this is a by design product
issue. Unfortunately there is no public hotfix for this issue now. If this
issue is urgent to your business, I recommend that you contact Microsoft
Customer Support Services (CSS) to see if they can release a quick hotfix
separately for you. Please be advised that you may be charged at first when
you make a call however all the charge will be refunded at last if it is
proved to be a product issue.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.

If you have any other questions or concerns, please feel free to let me
know. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

Reply to this Message

Mike C# - 06 Mar 2008 22:52 GMT

You can log to the database, and you can even extract just the information
you want during that logging as well:

http://blogs.sqlservercentral.com/michael_coles/archive/2007/10/09/ssis-custom-l
ogging-the-easy-way.aspx

> Hello,
> We use SSIS packages (dtsx) for databases synchronization. The packages
[quoted text clipped - 14 lines]
> Thanks,
> eXavier

Reply to this Message

Charles Wang[MSFT] - 07 Mar 2008 11:10 GMT

Hi Mike,
Just clarify that this way could not solve eXavier's issue which is for
those messages regarding package starting and finishing recorded in event
log.
Anyway you give a good point for recording logs generated from interal SSIS
package.

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

Reply to this Message