ssis How to use variables inside a script component
Introduction
This post provides steps to use variables (User Variable, Package Parameter and Project Parameter) in the script component and viewing the updated value using Breakpoint and Watch window.
Parameters
| Parameter | Details |
|---|---|
| UserVar | It is like a local variable used inside a package. Its value can be read and modified in script task |
| Result | It is a local variable which will hold the concatenated result. Its value can be read and modified in script task |
| PackageVar | It is package parameter, which can be shared between packages. Its value is read only inside script component |
| ProjectParm | It is project parameter, which is available after deployment as a configuration. Its value is read only inside the script component |
