SSIS - 2008 R2 on a Windows 7 machine accessing a remote server - which I think is 2003.
I'm trying to run a WMI Data Reader Task to get sub folders from a specified directory.
This simply generates a [WMI Data Reader Task] Error: An error occurred with the following error message: "Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))".
I'm using a service account - svc-remoteServer. If I put in the server, account name and password into the WMI connection and test - it works fine.
If I run wbemtest.exe and connect to the remote server as the service account, and execute the query - it works fine and returns all subfolders. It just won't work when I execute the Task.
I've tried specifying the username, password and server name. I've also tried specifying the connection string - as follows