How can you add a recordset variable in the Script task?
You can use variables in the script tasks for exchanging the data with other objects of the packages. The script task uses the property “variables of Dts object” to read and write the variables object of the package. For making the variable available to the custom script, you can add them to the read-only or read-write variables list. These variables are case-sensitive, so make sure that you add the right variable name to the list.
