i have added Database server in the HOST. And running the SQL script through "run sql script panel". The script is "backup database dcadb to disk='C:\test\dcadb_r11.bak' with init". Now i want to use IA variable instead of hardcoded path.
script should be "backup database dcadb to disk='$PATH$$/$dcadb_r11.bak'"
Yes, you can use IA variables in your script, the only requirement would be to have them replaced with their respective values BEFORE running the script!
