"Login failed. The login is from an untrusted domain and cannot be used with Windows authentication

I am trying to connect SQL server database to AWS RDS instance. My destination table is on AWS RDS instance. When connecting, I face below issue since the windows authentication is used in the job instead of SQL server. I need the package to pick the SQL server credentials instead of windows. Please help me solving this issue

Connection manager "DestinationConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Driver for SQL Server" Hresult: 0x80004005 Description: "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.". End Error Error: 2021-05-12 14:50:50.47 Code: 0xC00291EC Source: Execute SQL Task Execute SQL Task Description: Failed to acquire connection "DestinationConnectionOLEDB". Connection may not be configured correctly or you may not have the right permissions on this connection