I Have created a DTS package which imports data from an access 97 database to an SQL Server 2000 database. I have saved the package as a SQL Server file and it works when executed. The problem is when i then delete the new database from SQL Server through enterprise manager, and try to execute the saved DTS file again, this time it just fails, and says :
"Cannot open database requested in login 'db2'. Login fails."
Any ideas on why this is happening?