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.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 Web Service Implementation

Author  Topic 

pdude
Starting Member

5 Posts

Posted - 2010-02-20 : 01:27:35
Hi

I've been tasked with implementing a web service which pushes data from our SQL Server 2005 database to an end point at an external agency. The web service would also need to run after a job on the server has finished.

Can this be done natively in SQL sever 2005 (with schema collections enpoints and or SSIS) or do I need a .net interface? If I need to go down the .net path - how do you integrate the aasembly into SQL server and how do you run it on a schedule?

Any assistance or pointers would be appreciated!

pd

naveengopinathasari
Yak Posting Veteran

60 Posts

Posted - 2010-06-11 : 09:21:46
Hi,

I would prefer to have an SSIS implemented to push data from Sql server to an external source, which is very flexible.

Lets unLearn
Go to Top of Page
   

- Advertisement -