How do you execute the package? SQL Server Agent? In that case you might have to set up a proxy account with a user that has rights to read from the database.