SSIS: can we make 'Logging' configurable in SSIS (VS 2012)

Dear Folks,

Can we make "Logging" as configurable in SSIS using Visual Studio 2012 at run time?

Actually, we have configured error logging in 'SQL Server' database. But we would like to turn off at run time.

Best Regards,
Mohit Pandit
LVL 5
MohitPanditAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rainer JeschorConnect With a Mentor Commented:
Additional info:
Location is
Package.Properties[LoggingMode]
and possible values are:
UI Value - Numeric Value (to be set)
UseParentSetting - 0
Enabled - 1
Disabled - 2
0
 
Rainer JeschorCommented:
Hi,
you can set the property "LoggingMode" on the package. This can also be set using an expression.
Therefore you can even store a variable in either a database table, XML or as project parameter and use this value in the expression.
HTH
Rainer
0
 
MohitPanditAuthor Commented:
Okay, I shall check & get back to you.
0
 
MohitPanditAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.