Yes, any reference to that database will have to be changed to the new name; whether in SSIS, query, connection string, etc. Best to log all connections to that database for a while and see where they are coming from and get a consolidated list before renaming.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot