Anytime, good luck. If you have a moment to circle back, I would be interested to hear about where you landed, and how you got there. Of course if you...

A better option would be to call the web service from your application code and submit the resulting XML to the stored procedure for further use and inspection, i.e. do...

I would not put much stock in that post. The suggestion that macros are...

Sure. I developed the C# code I posted inside an SSIS Script Task. You'll just need to add a reference to Microsoft.Office.Interop.Excel.dll in the Script Task VSTA Project (what opens...

To access a Java web service you would have to use SQLCLR but why would you want to do that from inside your database engine? What are you trying to...

Correct. Writers do not block...

Not at all. My response was admittedly a bit Spartan.

Office objects are designed to be used on a client system, not a server, and they are notorious for having memory...

Sure, CDC is an option but if you do not need a record of all historical data changes...

Philip-1144230 (1/10/2013)

---

Hey opc.three,

Thanks for the reply.

This sparked anther thought that I would like to run by you and anyone else who might have more insight into CLR Procedures.

Would it be...

Related post. Direct replies here:

http://www.sqlservercentral.com/Forums/Topic1405106-146-1.aspx

What you see with the DMVs is the input buffer, i.e. the last batch. If you did not have a Trace or Extended Events session running then the information is...

Looks like A and B are polar opposites, as are C and D, so if only one choice could be correct then I would also go with E.

C# is not an option :crying:

Here is a mockup of some code for a Script Task that reads a Worksheet row-by-row and accesses the Hyperlinks collection for each row. I...

How about something like this:

-- change to Text Results (press Ctrl+T) before running

-- change this to whichever database your selecting from

USE [YourSourceDatabase];

-- change this to the destination database name

DECLARE @targetDatabase...

Nice offering MM. The technique is one I have seen outlined before but not necessarily applied to SSIS. While no one step is difficult there are quite a few of...