How SQL Server maintenance plans work in relation with Jobs and DTExec?
I am specially interested in the mainteance plan's local connection parameter,which seems to be passed somehow to dtexec.
I have read some docs but none of them is clear enough. As I have understood this works as follows: the MP creates a SSIS package as well as a job... and the job in turn invokes the external aplication dtexec to execute the SSIS package. This package run by dtexec has to access (back) the SQL Server and to achiev that it uses the account provided by the "local connection" parameter of the maintenance plan.
Is my understanding right?
Some reference to MS official detailed documentation would be welcome.
Thanks in advance,