My SQL server is SQL 2000. The DTS package uses SQL anthentication to
transfer data from database A to database B. It fails. The error message
shows Windows NT user or group 'A\Guest' not found.

In DTS package, on Copy SQL Server Objects Task Properties screen, if I
don't select Create destination objects, copy data works. However the
destination tables do not have keys adn indexes.

How can I fix it? Any thoughts?