How to store a result set of an execute sql task in a variable ?


  • If my sql result set is a single SQL String, I want to be able to assign it to an SSIS string variable. If its a SQL datetime, then I want it to be assigned to a SSIS datetime. etc. 

    Can i do this directly or do i have to store result set into a "single row" ie SSIS object and then use a script task to assign that "single row" to an SSIS variable ?

    Saturday, November 16, 2013 8:12 AM


All replies