Hi,That's literally what that code says.Campaign's expressions are an abstracted sql that are translated directly or run as db functions, for compatibility across db's.Here 'iif' translates to 'case-when-then-else-end'.Adobe Campaign Classic is primarily a data management tool, it would be a good in...

Hi,I haven't used that tab, which is probably there for post-activity scripting.You want to alter the activity's config in the init script under Advanced tab- path is activity.extraction.select.Thanks,-Jon

Hi,Sounds like an analyst interview question .Just add a split after your query and limit by sort.Thanks,-Jon

Hi,Use post-processing workflow, in the delivery routing's external account.Out of curiosity, why are you using a workflow with a sql activity to update nms:delivery on every delivery creation?Thanks,-Jon

That's a sql expression, goes in the extraction activity.

Hi,Iif(Charindex(@phone, '+') = 1, Substring(@phone, 2, Length(@phone)), @phone)Thanks,-Jon

Hi,Export the workflow, alter it in notepad, import it.Thanks,-Jon

Hi,Users need 'admin' right to use package import functionality.Thanks,-Jon

Hi,Use `ls -l` to get file sizes from sftp:https://linux.die.net/man/1/sftpNB Security-wise and general coding practices-wise, you shouldn't store login credentials in plaintext or use action-at-a-distance and state when it's not required. Also use keys instead of passwords for auth if possible.Than...

HI,As I said, it's the hard way:Create a custom addMethod function with the same interface as HttpSoapConnection's addMethodHave new addMethod call HttpSoapConnection's addMethod, then replace the function it creates with code that calls the replaced function while logging its inputs and outputsChan...