Many people are quite confused on how parameters and variables work. However to clearly demonstrate the differences, you need to deploy a package in the SQL server. Parameters There are 2 types of Parameters: Package Parameters and Project Parameters. The only thing to that differentiates in these 2 types is the scope. Project parameters… Continue reading