title: Impersonation for sp_OA* on SQL Server 2000
body: <p>Is there any way to impersonate for sp_OA* calls?  I'm specifically using this for file system management, and I'm doing everything in TSQL to avoid DTS since there's a possibility of upgrading to 2005 and I want this solution to be cross-version.  Unfortunately, I need to access remote file systems but I can't get AD permissions added to the system account for one of the servers (it's under the radar and not on AD, though it runs a production ETL cycle).  Is there any way to impersonate for this?  I'd take an xp_cmdshell solution too; I just want it to be possible at all to avoid developing for both DTS and SSIS and juggling two code bases.</p>
  
  <p>Again, this is not impersonation for execution of SQL Server objects; this is for accessing non-SQL Server resources using an account other than the SQL Server system account.  The only solutions I've been able to find involve SQLCLR on 2005+, not that I would be able to deploy assemblies anyways.  (I'm a consultant outside IT and there's political stuff.)</p>