Retrieve Data from Web Services Using DTS (SQL Server 2000)

Hot Topic

Error importing data from oracle database to an SQL database
NTEXT Data Type Problem
Management Studio - view DTS package logs (SS2005)
Clustered Index creation uses extremely much diskspace
SQL Server 2005 Installation does not install sqldmo.dll
StrToMember Execution Problem
deploying report models
New Query button -- always prompts for authentication
Replication Deadlocks
BCP,CTE,NTILE

SQL Server

Configuration Error on Encryption Key
SMSEE no longer launches, after SBO is installed...
How to view Cube in WEB Browser(IE) like Pivot tables of Excel
SSIS Package Validation taking a long time
sql mobile question
Alter column question
Database Snapshot on tempdb
Database Mirroring: Cannot set the Mirror Server instance as the partner on Principle server
Huge issue with the Lookup problem
Insert with condition

Retrieve Data from Web Services Using DTS (SQL Server 2000)

The project I'm currently working on involves combining data from one SQL Server 2000 databases and XML returned from a web service into a 3rd SQL Server 2000 database.

This process must be scheduled to happen once a day. If it weren't for the Web Service, I'd say that this is a no-brainer and I'd use DTS. However, I'm not sure if I can even access a Web Service with DTS. Has anyone done this or have any tips

Answer this question

Retrieve Data from Web Services Using DTS (SQL Server 2000)

fikry

Id try the microsoft.public.sqlserver.dts forum if I were you.

-Jamie
Retrieve Data from Web Services Using DTS (SQL Server 2000)

Answer this question