Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
DTS to transfer data from different database failedPlease ignore if it is not in the right discussion group. 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? Thanks.
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
