sql server dts: I recieved this error 'SELECT permission denied on object
'FEIProviderAddresses', database eRW owner 'dbo'' on a failed DTS package.
Can someone explain to me what this means and how do I correct?

--
Message posted via http://www.sqlmonster.com

[quoted text, click to view]

Hi Jay,

It means that the user account that is executing the DTS package does
not have permission to select from the table 'FEIProviderAddresses'.

When a package is executed, it uses the current user credentials,
however when you schedule a package to run, it runs using a service
account. You need to make sure that whichever account is executing
the package (yours or the service account) has the correct permission
on the database.

Good luck!
J