Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Transfer log-ins DTS task

Status
Not open for further replies.
swoodring

swoodring

Programmer
Dec 7, 2000
114
US
I am trying to use the DTS transfer login task to transfer my logins from my SQL 7.0 server to my sql 2000 server. These are on different machines. I've created a new package on my new server - SQL 2000. I've selected the transfer log-in task, under properties/source I have PRFDSS which is my sql 7.0 server/under destination I have PRF_SQL which is my SQL 2000 server. Under Log-ins I selected all server logins detected at run time.

When I run the task I get an error stating unspecified error. I'm running this task from the new server. SQL 2000 server. Any ideas whats wrong?

Stacy
 
Status
Not open for further replies.

Similar threads

Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
578
Chris Miller
Chris Miller
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
604
Chris Miller
Chris Miller
Auguy
  • Locked
  • Question
SQL 2014 Truncate Log File
Replies
2
Views
234
Auguy
Auguy
Jago11
  • Locked
  • Question
When to use 1=1 logic 1
Replies
7
Views
468
Andrzejek
Andrzejek
TheBugSlayer
  • Locked
  • Question
How to make xp_cmdshell use SQL Server's bcp utility instead of Sysbase's 1
Replies
7
Views
1K
Nick_Evans1
Nick_Evans1

Part and Inventory Search

Sponsor

Back
Top