Hi ronan

I can see you problem now and probably why it's not been. Lear to others.

Your using a SQL task but have put in ssis expressions. They are very different things so you can't mix them as your code is trying to do.

To point you in the right direction you can do this one of two way:

1st option: Declare a package variable and use an SSIS Expression to generate the SQL statement and the have a second step to execute that sql statement, by using a SQL task where the source type is your variable.

2nd option: The second option is first create two package variables and set them to evaluate as expression for these two lines

'"+ (DT_STR, 6, 1252)DATEDIFF("ss", @[System::StartTime] , GETDATE() ) + "',

'"+ (DT_STR, 6, 1252)DATEDIFF("ss", @[System::ContainerStartTime] , GETDATE() ) + "',

.... Without all the double quotes etc.

Then use a SQL task either your SQL statement, replacing the package variables with a ?

I.e.

VALUES

(

,?

,?

,?

) etc etc.

Then use the parameters table to map the package parameters in order ( these will replace the ?)

Hope that makes sense