SQL 2005 equivalent of DTS? SQL 2005 equivalent of DTS? dgillz (Instructor) (OP) 18 Mar 09 04:41 So where did DTS go? What do I use in its place in SQL 2005? All I really want to do is import some data from an excel spreadsheet into a SQL table. I could do this in seconds with STD in SQL 2000 but I cannot see where to do this with SQL 2005.Any insights appreciated. Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:www.gainfocus.biz/exceladdin.html RE: SQL 2005 equivalent of DTS? HarleyQuinn (Programmer) 18 Mar 09 04:56 Since 2005, the functionality to create new DTS packages has been superseeded with SSIS.More information can be found here and there's a Tek-Tips forum for any questions - forum1555: Microsoft SQL Server: Integration Services (SSIS)Hope this helps HarleyQuinn---------------------------------The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe MartinGet the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.