STX runtime

[rofltrain]

quick question - if you link to an stx file (i.e. in the script task
plus, or script component plus), will that linked file get loaded at
runtime, or will it only change at design time?

e.g. if I create a solution, and link to a common script (e.g. "move
files" or similar). I then deploy this as a SQL agent job. If I modify
the common script on the network share, will the job in SQL agent
automatically pick up the change next time it's run? Or do I need to
open in in Visual Studio, load the script, then redeploy?

[Ivan Peev]

The modified file from the shared location will get loaded at runtime
if you are "linked" to the script. If you break the link (press the
button again), the script will no longer load from the shared
location.

[rofltrain]

Interesting.....

What happens if the modified file in the shared location is moved?
Will the job just fail?

Can you set the path to the STX file as an expression?

What happens if the STX file is altered to add in new (optional)
properties? e.g. if a new property is added, but not required, will
the existing packages using the script still process successfully?

[Ivan Peev]

1. If the shared script file doesn't exit, the task will fail.

2. Yes, you can use an expression to setup the path to the shared
script file. The path is contained in the ScriptLink property.

3. The property value is stored as variable and the context is the
task. The variable is named _<PropertyName> If you have a new property
and no variable for it, the task will still work.