i have a script this is it

Public Sub Main()

Dim S As String

'Building a string that proof that the values of the variables

' is originated from the event fires in the child package

S = "TaskName: " & Dts.Variables("System::TaskName") _

.Value.ToString() & vbCrLf _

& "SourceName: " & Dts.Variables("System::SourceName") _

.Value.ToString() & vbCrLf _

& "SourceDescription: " & Dts.Variables("System::SourceDescription") _

.Value.ToString() & vbCrLf _

& "MachineName: " & Dts.Variables("System::MachineName") _

.Value.ToString() & vbCrLf _

& "PackageName: " & Dts.Variables("System::PackageName") _

.Value.ToString()

'Showing the string value as a message box

MsgBox(S)

Dts.TaskResult = ScriptResults.Success

End Sub

seem to be right when the message box pops up pops up the right descriptions.

this script runs into my sql so it insert it into the table but its still just adding in the @+Task name etc

here is my script

INSERT INTO [dbo].[SSISLog]

([EventType]

,[PackageName]

,[TaskName]

,[EventCode]

,[EventDescription]

,[Host])

VALUES

(

'OnPostExecute',

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

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

0,

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

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

)

what am i doing wrong it wont populate the table right