SQL 2005 equivalent of DTS?
SQL 2005 equivalent of DTS?
(OP)
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.
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?
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 Martin
Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.