Cannot convert 'System.String' to 'System.Int32' Error in SSIS Expression Builder

211 Views Asked by At

I'm getting an error every time I evaluate this expression in my Expression builder. I'm getting a Cannot convert 'System.String' to 'System.Int32'. Anyone knows why it does so?

"
INSERT INTO lgs_FOS_Extract_Errors VALUES('"+ @[System::MachineName] +"','"+ @[System::PackageName] +"'," +(DT_WSTR, 12)@[System::ErrorCode]+ ",'"+ @[System::ErrorDescription] +"',GETDATE())
"

I tried to one by one remove every values but I can't find where the error coming from. I am expecting to find the write expression for my SQL task

0

There are 0 best solutions below