It seems logical to use a sqlvariant given the horrors of importing a field where the data looks like this: Column 1:1 1:1 Considered 1:2 2:1 Undetermined   What...

So ... presumably you checked the log. What did it say?

Save the filename in an SSIS variable at the point where it is created, then use that in your subsequent copy.

After installation I noticed that SQL server  don't work

Please go into more detail about the "don't work" part.

I don't think you can because the hash is created internally based on a structure in the optimizer, not the T-SQL text, that would also have to be recreated....

For 10,000 rows, it could well be faster (and simpler to code and maintain) for you to do a full truncate/reload every time.

Unless you have a reason not to?

Which hash are you referring to?

Which tool are you wanting to calculate the hash with?

Which engine are you referring to? The Mazda I have at the moment is pretty fast,...

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 6 years, 8 months ago by Phil Parkin.
• This reply was modified 6 years, 8 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...