Munna,
The statement shown is part of an ActiveX Script task modifying the SQL statement for a DTS Execute SQL task.
An example for this functionality in SSIS can be found at: http://www.sqlis.com/post/The-Execute-SQL-Task.aspx. You could either pre-define a variable as shown in Passing in the SQL Statement from a Variable, use Parameters to set the SQLStatement as shown in Returning a Single Value, Passing in Two Input Parameters, or use Expressions to set the value of SQLStatement.