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 |
|
NoDice
Starting Member
4 Posts |
 Posted - 2003-10-31 : 17:08:00
|
| Hi,Another question. I was wondering if there was a more direct way to expose a DTS package as a web service than through calling a stored procedure. From what I've found, the most direct way is to use SQLXML to expose a SP and then call the dtsrun utility in the sp. Likewise, is there a direct way to call a web service from a dts package?Best,DJC |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-11-02 : 09:36:05
|
| DTS is a fully COM-compliant architecture, so you can take your existing DTS packages and write them as VB or C++ code and then wrap them into a web service. It's a little more work but gives you a lot more power and flexibility.This site has some really good information on advanced DTS:http://www.sqldts.com/ |
 |
|
|
NoDice
Starting Member
4 Posts |
Posted - 2003-11-03 : 11:08:58
|
| Thanks for the prompt input all! |
|
|
|
|
|
|
DTS packages and web services