I got this error:
Error: 0xC0202009 at BulkInsertTask, Connection manager "localhost.AdventureWorksDWDenali": SSIS Error Code

DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Login failed for user 'servername\myusername.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description:

"Cannot open database "AdventureWorksDWDenali" requested by the login. The login failed.".
Error: 0xC002F304 at Load Zip Codes, Bulk Insert Task: An error occurred with the following error message: "Exception from HRESULT: 0xC0202009".
Task failed: Load Zip Codes
------------------------------------------------------------------------------------------------
I looked up in the solution and found this:

Resolution:

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.

I am not sure how to do this and would appreciate any help! Thanks

Emily