SQL 2005 equivalent of DTS?

dgillz · Mar 18, 2009

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 · Mar 18, 2009

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.

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!

SQL 2005 equivalent of DTS?

dgillz

Instructor

HarleyQuinn

Programmer

Similar threads

Part and Inventory Search

Sponsor