Hi,
how can you give a Windows account bulkadmin/sysadmin role in SQL Server so that it is used when running a SSIS package via dtexec?
I tried adding a login in SQL Server for my Windows account, and giving that account even sysadmin role, but this has no impact.
This is a surprisingly difficult task! Anyways we probably try and configure these tasks (run earlier straight through Integration Services) as agent jobs so that they can be started remotely. Still - who does like to leave something undone because it cannot be solved... :blush:
-- Satu