How to enable or disable LOGGING using task,package?

Question

How to enable or disable LOGGING using task,package?

nikku

Ten Centuries

Points: 1103
More actions
April 24, 2014 at 6:53 am

#151343

Hi All,
I have created SSIS package which keeps the track of SysSsisLog table into another table. However I want an option to keep loggin ON or OFF through task/package by passing parameters 0 - ON , 1 -OFF. Is anybody came across such requirement or done this type of code before. Please let me know.
Thanks in advance 🙂
Nikhil

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 1

I'm not sure it is possible. Either you log, or you don't.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 2

Nikku (4/24/2014)
Hi All,
I have created SSIS package which keeps the track of SysSsisLog table into another table. However I want an option to keep loggin ON or OFF through task/package by passing parameters 0 - ON , 1 -OFF. Is anybody came across such requirement or done this type of code before. Please let me know.
Thanks in advance 🙂
Nikhil

What version of SSIS?

😎

nikku Ten Centuries Points: 1103 More actions · Answer 3

nikku

Ten Centuries

Points: 1103

April 24, 2014 at 11:22 pm

#1708661

I am using 2008 R2 version.

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 4

For SSIS 2008, the simplest way I have found to manipulate the logging is to use a Scrip Task in a "Master" package.

As the logging is initialized before any other parts of the package, it is impossible to change this at runtime. The workaround is to use a parent or master package, load the package into an app variable and manipulate it before execution. A simpler alternative is having two packages, one wit logging and the other without.

😎

nikku Ten Centuries Points: 1103 More actions · Answer 5

nikku

Ten Centuries

Points: 1103

April 25, 2014 at 12:57 am

#1708678

Thank you Sir 🙂

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 6

Eirikur Eiriksson (4/25/2014)
For SSIS 2008, the simplest way I have found to manipulate the logging is to use a Scrip Task in a "Master" package.
As the logging is initialized before any other parts of the package, it is impossible to change this at runtime. The workaround is to use a parent or master package, load the package into an app variable and manipulate it before execution. A simpler alternative is having two packages, one wit logging and the other without.
😎

It's still all or nothing (and I'm OK with that). I see no reason why one would want to switch off logging during an execution.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 7

Koen Verbeeck (4/25/2014)
It's still all or nothing (and I'm OK with that). I see no reason why one would want to switch off logging during an execution.

I agree, cannot see an obvious reason to switch it off. Normally one would be changing the log configuration depending on the environment and that's of course where the package manipulation comes in handy.

😎