I'm trying to run an executable from an SSDT package using the Execute Process Task. Simple test Processes (like a hello_world.bat) run fine, but the executable I need to run requires elevated privileges. (Trying to run MyEventViewer, a program that transfers event viewer entries to a table). The executable requires administrative privileges.
The error is "The requested operation requires elevation." I don't see how to elevate a task in SSDT.
Thanks in advance.