Tag Archives: SSIS Script Component Read Variable

This blog article shows you the code snippet to read the variable in Script Component of SSIS. The code snippet as follows. public override void CreateNewOutputRows() {     VariableDispenser variableDispenser = (VariableDispenser)this.VariableDispenser;     variableDispenser.LockForRead(“User::varStartDate”);     variableDispenser.LockForRead(“User::varEndDate”);     IDTSVariables100 vars;     variableDispenser.GetVariables(out vars);     string strStartDate = … Continue reading →