OLEDB ACQUIRE CONNECTION ERROR SSIS
Hi I am getting this error in my SSIS packages on alternate days
An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.The AcquireConnection method call to the connection manager "" failed with error code 0xC0202009.
Symbolic Name: DTS_E_OLEDBERROR The hexadecimal value for this error number = 0x80004005.
I found the solution in Microsoft site
To resolve this issue, you must change the permissions for the Temp directory of the SQL Server Agent Service startup account. Grant the Read permission and the Write permission to the SQL Server 2005 Agent proxy account for this directory.
But where do i find TEMP directory for Sql Server agen开发者_开发技巧t Service start-up account in my system . Since I could not locate it in my system . plz help me how to go ahead with that change.
Thanks mushtaq
I believe the temp directory is here:
c:\Documents and Settings\<Account>\Local Settings\Temp
精彩评论