Database Reference
In-Depth Information
Figure 17-14
.
Package configured for Execute SQL task-based dynamic configurations
Setting Values Using a Script Task
An alternative to retrieving your configuration with an Execute SQL task and setting
package properties through expressions is to use a Script task. This approach can be
useful if your values aren't coming from a database or they require additional process-
ing logic—for example, if they are coming from an encrypted source. From within a
Script task, you can easily read values from external configuration files (such as an
Search WWH ::
Custom Search