Post reply

DTSGlobalVariables.Parent.Tasks

  • December 28, 2008 at 7:43 pm

    #197968

    Hi,

    I would like to convert the below from DTS 2000 to SSIS 2005.

    DTSGlobalVariables.Parent.Tasks("DTSTask_DTSExecuteSQLTask_2").CustomTask.SQLStatement = sSQLString

    Please let me know how I can do thin using .Net

    Thanks

    Munna

  • December 29, 2008 at 7:30 pm

    #918715

    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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply