ssis How to use variables inside a script component

Help us to keep this website almost Ad Free! It takes only 10 seconds of your time:
> Step 1: Go view our video on YouTube: EF Core Bulk Extensions
> Step 2: And Like the video. BONUS: You can also share it!

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


Got any ssis Question?