Hello, this is related to SQL 2008 but the answer could be the same.
When using SQL 2000 and DTS a user could open, modify and execute a DTS package via EM on there machine.
The catch was when a DTS package was run on there machine it would use there local logon credentials as the security context that the code would run under on the server.
This would mean that if the use had limited rights and the package had for example an xp_cmdshell task the user would not be able to execute the package.
A SQL job would work ok.
Could somebody please explain or point me in the correct direction with regards to a user opening an SSIS package in BIDS and executing it.
Will the permissions work the same way (i am not talking about a user importing or deploying a package etc) just the process of executing it from BIDS.
Thanks