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