SQL and Installer Properties

[jjones]

Is it possible to use an Installer property in an Inline SQL script? I need to pass a file location to a SQL script so it knows where to store a database backup.

[Eusebiu]

Hi,

The installer properties cannot be used directly in an inline SQL script, however you can use the method described in the How to use a custom property in a SQL script? article to achieve this.

Best regards,
Eusebiu