December 20, 2011 at 7:54 am
Hey there,
Anyone knows why I'm getting every event twice in the msdb log table? One prefixed with "User:" followed by the event name and one without that prefix?
sample:
Ideventsourcemessage
310User:PackageStartPackageNameBeginning of package execution.
311PackageStartPackageNameBeginning of package execution.
Thanks,
December 20, 2011 at 11:15 am
Solved.
I'm currently using a master Package that launches several subpackages and using the logging option to calculate several metrics.
In every packages (MasterPackage included), i've enabled the logging option saving to SQL Server msdb sssislog table. Inside the master package at the "Execute Package" Task (EPT) level, i've set the LoggingMode option to "UseParentSetting".
After several tests, it seems that those rows are generated by the fact that the LoggingMode at the EPT is enabled (or useParentSetting). Disabling that option at the EPT level, stoped writting those additional rows to the msdb table.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply