Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  DTS package failure - wrong DB accessed!

Author  Topic  ashaig Starting Member 2 Posts Posted - 2001-11-08 : 11:09:36 I'm trying to export 3 tables to my ISP's server from my PC. I keep getting "UserId (myID)not a valid user on (database I've never heard of)" My ISP can't or won't help, seeing it as a problem I have created. I can't see how. I used the wizard to create this package. Opted for 'Transfer Objects and data', 'drop destination tables first', 'replace data'. I've double-checked that I'm pointing at the correct server, and using the correct UserId/password. I'm using NT authentication at my end, SQL at the other.