MS SQL Server - DTS to transfer data from different database failed

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

DTS to transfer data from different database failed

Sean

2006-01-30, 11:23 am

Please 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.

Sponsored Links