Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Expression might contain invalid token SSIS

I try to execute a simple sql task with variable, so I create my variable and into it I insert delete statement like:

DELETE FROM fiscal_cxp WHERE EMPRESA = '"+@[User::cia]+"' 

but when I try to evaluate expression I get an issue:

enter image description here

I review query several times but I dont find nothing wrong. Can someone knows what is wrong there? Regards


1 Answers

You're missing the opening and closing quotes:

"DELETE FROM fiscal_cxp WHERE EMPRESA = '" + @[User::cia] + "'"
like image 53
Chris Mack Avatar answered Oct 25 '25 13:10

Chris Mack



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!