I don't think you are missing anything simple.

Are you able to revisit the 'data must be live' requirement? If it transpires that a 10-minute latency period is acceptable, it potentially...

Going back to the script task, you do not need to know variable names in order to iterate round the variables collection. Here's a chunk of code I copied from...

• This reply was modified 7 years, 2 months ago by Phil Parkin.
• This reply was modified 7 years, 2 months ago by Phil Parkin. Reason: Improve C# snippet

As you are using an expression to define the Execute Process command, I would suggest that you put a debug breakpoint on the EP task and then check the run-time...

OK, is part...

How did the data previously get from the remote databases into your locally hosted 'existing' table?

Have you tried setting a breakpoint and then inspecting the contents of the various variables? Might provide some useful insight.

Also, if you are looping round resp.ResponseData, what is the point...

What is the exact text of the error message?

Is this something which used to work and has suddenly stopped, or has it never worked?

This post may be of interest.

I'll reproduce the code here:

DECLARE @s VARCHAR(25),
@Iteration INT;

SET @s = 'ABCDEF';

SET @Iteration = LEN(@s);

WITH E1 (N)
AS (SELECT 1
UNION ALL
SELECT 1
UNION ALL
SELECT...

Not that it makes too much difference, but what is the input format? Is it a single delimited string, or a recordset?

So this should be fine? select a.*, b.full_name from alt_id_view a left outer join all_clients_view b on a.people_id = b.people_id It's only bringing in the matched so it could...

Hello, I am trying to see all records, even those which do not have a match on table b. I tried full outer join but the results were the...

It just depends on the nature of the table.. if I can avoid deleting data I prefer to do it another way, whether that is checking if the table...

• This reply was modified 7 years, 2 months ago by Phil Parkin. Reason: Improve English

There is no guarantee that CHECKSUM_AGG() will return a unique value for every different recordset, so 'fixing' the proc is not really an option unless you are prepared to use...

...

Right now, my priority is to wait a few more days for the water to warm up. Predicting some time to relax and pull in some crappies. And maybe...

Could be the 'new' cardinality estimator (introduced in 2014). Lots of links all over, but you could start with this.