"sarahspace@gmail.com" wrote:

> Over the last several months, I have seen a handful of DTS packages
> fail with the error "Login (loginname) does not exist". The logins do
> exist and the password are valid. I can connect to the database using
> the same credentials and I can create a new DTS package that will
> successfully execute with the same credentials. The error is not
> localized to a particular server or package type. The only thing that
> will fix these errors is dropping the login and recreating it using
> the same name and password. Does anyone have any insight on what
> might be happening?
>
> Thanks
>
> Sarah
>