What do you mean by "user input"? What client application...

Please note that I hit 'Report' when I meant to hit 'Quote' and there seems to be no way of reversing that ... apologies.

This makes no sense to me -...

On a side note, if you have any control over the structure, you would be better off storing the date as a DATE or DATETIME field.  Then it can...

Presumably you've done...

Rant understood!

The only possible non-GUI way I can think of for adding these variables to multiple packages is as follows:

1. Keep a copy of an unmodified package
2. Modify the package...

Config data should be held in parameters, not variables.

Assuming you are using the project deployment model, parameters can be added at the project level.

So you can do it all in...

Are you saying that you have multiple packages to modify and each of them needs to have the same 10 variables added?

Can you provide some background on the requirement? There...

Why not just

SELECT * INTO [Database].[Schema].[Table]

FROM #tmp_Table

WHERE 1 = 0

?

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,...