I totally agree. SSIS information, on the net, is difficult to find. Books are few and far between. General SQL 2k5 books usually have just a simple chapter on SSIS that explain only the tasks, but don't really use a real-world example.
I'm hoping that I just haven't *found* the right book and that it *is* out there. M!ke -----Original Message----- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 26, 2006 3:20 AM To: CF-Talk Subject: Re: CFMX 7.0.1 and MS SQL 2005 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238754 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
