How will you add a recordset variable inside Script Task?

1.	How will you add a recordset variable inside Script Task?
Answer» Variables are used in script tasks to FACILITATE data exchange with other objects of the package. Script task makes use of the property called Variables of Dts object for reading and writing to VARIABLE objects of the package. To make the variables available to the CUSTOM script, we need to add them to read-only or read-write variable lists. The variable names are case-sensitive and care has to be taken while adding the variables to the list. We can use the VALUE property for reading and writing data to the variables.

Discussion