troubleshooting Question
SSIS Determine if Running through VS
asked on
SSIS has a system property named System::InteractiveMode that BOL states:
Indicates whether the package is run in interactive mode. If a package is running in SSIS Designer, this property is set to True. If a package is running using the DTExec command prompt utility, the property is set to False.
However, this property appears to always be set to False, even when I am in Visual Studio and running the package interactively. I am using VS2019. I have been playing with this for the past couple of hours and it is starting to drive me crazy.
I need to reliably determine whether the package is running interactively or through our batch console using DTEXEC.exe as I need to set some other package variable based on this value..
Has anyone else run into this situation or come up with a way to reliably (without using user variables) determine whether a package is running interactively or via DTExec?
FYI, when just viewing the variables in the designer, it says the value is False. I would expect it to be True by default if I am actually in VS designer.
Indicates whether the package is run in interactive mode. If a package is running in SSIS Designer, this property is set to True. If a package is running using the DTExec command prompt utility, the property is set to False.
However, this property appears to always be set to False, even when I am in Visual Studio and running the package interactively. I am using VS2019. I have been playing with this for the past couple of hours and it is starting to drive me crazy.
I need to reliably determine whether the package is running interactively or through our batch console using DTEXEC.exe as I need to set some other package variable based on this value..
Has anyone else run into this situation or come up with a way to reliably (without using user variables) determine whether a package is running interactively or via DTExec?
FYI, when just viewing the variables in the designer, it says the value is False. I would expect it to be True by default if I am actually in VS designer.
The Value of Experts Exchange in My Daily IT Life
Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>
Mike
Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 6 Comments.
View membership options“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck
Member since 2004
Our community of experts have been thoroughly vetted for their expertise and industry experience.