• ya have it like that in my ssis package and get the same error

    [Execute SQL Task] Error: Executing the query "INSERT INTO [dbo].[SSISLog]

    ([EventType..." failed with the following error: "Conversion failed when converting the varchar value '"+ (DT_STR, 6, 1252)DATEDIFF("ss", @[System::StartTime] , GETDATE() ) + "' to data type int.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.