Also, the 0, 1, 2 ... parameter naming is valid for OLEDB connections. If you are using an ADO connection, you should include the actual parameter names.

Looks close. You should add the correct param size for the NVARCHAR column.

Quarter has an 'r' in it.

I do not understand your question (b). If you plan to call the...

I have never utilized this task - so I am not sure, but could this be a case where there isn't any output from the task so nothing to...

I think that the 'Package Execution Completed' text is usually green (not 100% sure) if everything worked as designed. Blue text means something else (not seen this documented anywhere).

How did you execute the package? Did you right-click and select 'Execute Task' by any chance?

Also, if you double-click on the precedence constraint (the line between the two tasks), a...

That should work! Assuming the first task completes successfully, that is.

Can you check the Output window after execution & look for any suspicious messages?

Looks easy enough. Did you try?

'Overwrite' is not a T-SQL RESTORE option. Did you mean REPLACE, perhaps?

With 550 columns it's not possible to test every combination of 2 or more columns to see if they are unique. It's a combinatorial problem with a search space...

There could (and probably will be) be multiple combinations of columns which are unique, based on existing data. That does not tell you which of the combinations, if any, you...

I agree with you.

I'm sorry, but I don't know how to write it any more clearly. To summarise:

1. Create a variable
2. Set the variable to the new file name using an Expression task...

Don't you just love it when you get a "urgent" work request that needs to be done "NOW", because it's impacting staff productivity, so you get the work done...

Just to elaborate, if you set up the other packages to run within a master package, you can then pass the variables that way.  If you're using SQL Server...

What do you mean by 'copy'? Where to? Where from? Using what tool?