hi

ya still get error with the single quotes on all line

INSERT INTO [dbo].[SSISLog]

([EventType]

,[PackageName]

,[TaskName]

,[EventCode]

,[EventDescription]

,[PackageDuration]

,[ContainerDuration]

,[InsertCount]

,[UpdateCount]

,[DeleteCount]

,[Host])

VALUES

(

'OnPostExecute',

'"+@[System::PackageName]+"',

'"+@[System::TaskName]+"',

0,

'"+@[System::SourceDescription]+"',

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

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

411,

2,

12,

'"+ @[System::MachineName] +"'

)