SQL 2005 equivalent of DTS?

[dgillz]

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:

http://www.gainfocus.biz/exceladdin.html

 

[HarleyQuinn]

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

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 Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.