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