locked
How to set result of SQL query into a variable using Execute sqltask in ssis? RRS feed

  • Question

  • How to set result of SQL query into a variable using Execute sqltask in ssis?
    Tuesday, August 28, 2012 6:52 AM

Answers

  • Follow these steps:

    1.In executable SQL task select a appropriate query that returns a result.

    2.Then in result set,select single row or full result set based on query.

    3.Now go to result set tab,add a variable of type string and select result name as the same name as  output parameter of  SQL command.


    If you have any problem please ask...

    Thanks..:)

    Tuesday, August 28, 2012 6:59 AM