hi

thanks for reply it will be going into an ssis package

so does it go in like this

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] +"

)