I thought that...

Do you want a stored proc to do this?

Are all of the detail rows created at the same time as the parent?

What is the PK of the detail table?

What is your objective? What extra benefits do you think a cursor will give you?

>> Also, considering that VALUES didn't actually come out until 2008, your lecture about getting rid of the old syntax "decades" ago is full of hooie.<<

If my arithmetic is...

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.