you would probably need to use a map drive action before and establish a connection to your core's directory that you want to execute the file from like:
Map Drive or Connect to Resource:
I don't want the file to be executed by each assigned client node, what I need is to execute a exe file just in the very Core Server by the core server itself. If I add a map drive and an exe file action in the provisioning task, then each client node included in this provisioning task will first map a drive to the core server and then will run remotely the file in the client node itself, and this is not my idea.
I need to run SQLCMD.EXE in the core server as soon as a software distribution task is started, and I don't know how to include this in the task.