i have create an SSIS and add an onerror in the event handler i added Execute SQL Task which worked fine all this time now it stopped work i deleted it an add a new one but still give me this error ([Execute SQL Task] Error: Executing the query "INSERT INTO [SIT].[dbo].[ FileNameError] ([P..." failed with the following error: "Incorrect syntax near 'SIT'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.)
and this is my insert statement "INSERT INTO [SIT].[dbo].[FileNameError] ([FileName],[ErrorCode] ,[ErrorDescription])
VALUES('"+ (DT_STR,255,1252) @[User::ErrFileName] +"'," + (DT_STR, 15, 1252) @[System::ErrorCode] + ",'" + (DT_STR, 1000, 1252) @[System::SourceName] + " :"+ (DT_STR, 1000, 1252) @[System::ErrorDescription] + "')"