Dates. Dates are the bane of working between database systems.

Try setting your variable type String and see what happens. You can always cast it as a date later.

You don't need to script it. You can create a variable and set the expression to the System::StartTime variable. Then use your variable in the rest of the package.

Variables and precedent constraints.

After your stored procedure runs add another Execute SQL Script to return the number of rows in the error table.

If it's 0 then...

I like what ZZartin is suggesting but perhaps you could dial it back a bit.

Make the staging table without constraints or at least to match the source data....

I worked with a very skilled database architect who thought nothing of using reserved keywords for field names. Since I was the consultant writing the T-SQL I changed them to...

I won't give you a step by step but I will give you the higher level things you should look into to make this work.

The very first is...