SSIS, CLR, sp_OAMethod or another method to call web method

6,360 pts.
Tags:
CLR
sp_OACreate
SQL 2000
SQL Server
SSIS
I have a question on which method is the best practice. I have been given a task to run a web service method every 5 minutes. There is one input parameter and no output to return. The service runs a bunch of functions to do data validation and then inserts into a DB2 database. (could not get a linked server to do inserts) I have been looking at examples using SSIS, CLR or just trying to call the method from a stored procedure using the "exec sp_OAMethod". What is confusing to me is I see a lot of posts contradicting each other as to the best way and some mention security issues because of the OLE connection. Which is a good way for a beginner to best understand this process. A lot of the Google results I've looked at are years old. Running SQL server 2000. (yes I know we should upgrade and it's on the list) Thanks in advance

Software/Hardware used:
SQL Server 2000
ASKED: July 8, 2013  6:42 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following