开发者

SSIS Expressions Not Working?

开发者 https://www.devze.com 2023-02-02 17:10 出处:网络
I have a SSIS package contai开发者_运维技巧ning an error variable that I would like to email out, but only if it is not blank (no errors).So, I put the constraint @[User::PackageError] != \"\" between

I have a SSIS package contai开发者_运维技巧ning an error variable that I would like to email out, but only if it is not blank (no errors). So, I put the constraint @[User::PackageError] != "" between the send email task and the processing tasks. Unfortunately, the email task never happens. I can print out the error variable immediately before this point, and it has all the errors in it, so that's not the problem... Do SSIS expressions not work with strings?

Thanks!

Edit: forgot to mention that if I switch the != to == it doesn't work either, but !isnull will make it work but gives no relevant info.


Ok. Figured out the answer. Even though there is no maximum length for strings, the expression editor cannot handle strings longer than 4000 characters.

The best workaround I have found is to use a script task to check the string. Either have the task return Success or Failure or set an int to be 1 or 0 and use that

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号