ssisHow 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

ParameterDetails
UserVarIt is like a local variable used inside a package. Its value can be read and modified in script task
ResultIt is a local variable which will hold the concatenated result. Its value can be read and modified in script task
PackageVarIt is package parameter, which can be shared between packages. Its value is read only inside script component
ProjectParmIt is project parameter, which is available after deployment as a configuration. Its value is read only inside the script component