Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-12 : 08:33:56
|
| Ryan writes "I'm interested in importing data into SQL Server 2000 via DTS directly from a web service. Is there an XML connection object that can be used as a Data Source in SQL DTS? I'm having a difficult time in finding information on the web about this. It seems like this would be a common thing for people to want to do.Thanks!Ryan" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-01-12 : 08:49:37
|
| I haven't seen one. You would be better off writing a small .NET app that you can call from DTS.Damian |
 |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2005-01-12 : 09:10:51
|
| >>Is there an XML connection object Version 3.0 of XMLHTTP can accomplish this. You would need to create an ActiveX script in your DTS package.As Damian points out though, ADO.NET has very good tools for these types of tasks. |
|
|
|
|
|
|
Importing XML Data with DTS