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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL server 2000 DTS designer components

Status
Not open for further replies.
lalitha1

lalitha1

Programmer
Oct 14, 2008
57
0
0
US
After installing SQL 2000 DTS designer components was anyone able to run the SQl 2000 DTS under legacy in sql 2005 management studio. I get error. Thanks in advance!
 
Sort by date Sort by votes
When I had to migrate from DTS to SSIS I found it more than worth the time to just rewrite in SSIS. The performance increase was more than what people had imagined. a 5 hour DTS process became a 20 minute SSIS process.
 
Upvote 0 Downvote
That's true, but I have more than 50 DTS and do not have much time left to rewrite them. I have moved all of them under legacy and installed SQl 2000 DTS designer components i get the following error:
""the DTS host failed to load or save the package properly" ANy help please.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Question
SSIS in SQL Server 2022
Replies
4
Views
137
grnzbra
grnzbra
minhtran360
  • Locked
  • Question
Where do I look for my SSIS pasckage that just being deployed to my sql server?
Replies
1
Views
107
mark williams
mark williams
marydn
  • Locked
  • Question
Send Nicely Formatted SQL Query via Email
Replies
0
Views
114
marydn
marydn
Cpreston
  • Locked
  • Question
DTS packages from 2008sp2 to SQL 2017 1
Replies
4
Views
102
Cpreston
Cpreston
hamzam
  • Locked
  • Question
Increment a series on sql
Replies
0
Views
39
hamzam
hamzam

Part and Inventory Search

Sponsor

Back
Top