Post reply

Exec SQL task fails on single row result set when empty

  • May 23, 2011 at 2:33 pm

    #250696

    I have an Execute SQL Task set to single row result set. Work fine unless the result set is empty, then it fails.

    Is there a way to handle an empty result set with an Execute SQL Task

    Other option is to build a data flow so I can at least handle the empty result set. then use a script component to drop it into my variable. Just seems like there should be a way to handle empty result set with an Exec SQL task.

  • May 25, 2011 at 8:02 am

    #1329671

    I would probably build it so that there was NEVER an empty result set. And add an expression as part of the condition to move onto the next step to see if there was a NULL or whatever value was chosen for "nothin".

    CEWII

  • May 27, 2011 at 8:21 am

    #1331022

    Thanks for the reply, the data source I was using was Pervasive. Probably just needed to research a bit more on how to write a statement that will always return a row.

    In SQL Server this stuff is easy, but Pervasive is a pain. I just used a data flow to execute my dynamic query then in the script component I simply provide a default when the rowset is empty.

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

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