On 4/26/06, Aaron Rouse <[EMAIL PROTECTED]> wrote: > Is DTS no longer in MSSQL 2005? >
Yes, Aaron, it's true, strictly speaking, DTS is no longer in SQLServer. HOWEVER >>>>> SQL2K DTS packages can be still used, and there has recently been an editor released for them, so you can convert them to work with SQLServer2005, but you can't create new ones. Instead, DTS has been replaced with a "more flexible, more powerful" application called SSIS. "More flexible, More powerful" means it's a programming language thing more complex than rocket science, and the documentation was written by Microsoft Techies, which means it's virtually unreadable. There are some tutorials around, adn some included in Books Online but not one of them involves moving data between databases, but rather between the database and flat files or access or excel spreadsheets - anything but between databases. So "officially" you havent lost any functionality with the new version, but in practice, despite asking repeatedly in every forum I can find, not one person can tell me how I can do what I need to do without getting a support guy to do it for me. In Enterprise Manager (which no longer connects to SQL2005 databases) I had my dev server connect every night to a number of databases, publish work done during the day to the site, take backups so I dont have to depend on the hosting provider to do it for me, and some other maintenance tasks, all done automatically every night. Now I can't. -- Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238745 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
