Home Forums SQL Server 2005 SQL Server 2005 Integration Services Assign a single column query value to SSIS variable RE: Assign a single column query value to SSIS variable

  • December 10, 2008 at 2:12 am

    #910155

    Just one question In the Execute SQL Task Editor, go to the Result Set Tab.

    Result Name should be 0 and variable name User::GetName

    Is this true?

    ( I am assuming your sql is select top1 contactname from ....)

    Regards,

    Mark.