Post reply

Script Failing after OLE DB Source returns no records

  • November 30, 2011 at 9:12 am

    #390997

    Hi there,

    I'm having a problem with my SSIS pkg that might be simple but some of things I've tried are not working.

    Here's the scenario :

    OLE DB Data Source "SELECT ID,NAME FROM TABLE_A"

    Then it moves to a "Data Transformation" Script.

    Because there is no records in the OLE DB Data Source, I'm getting an error when it goes to execute the script part.

    I've tried the row count and conditional split objects but I can't get it to work.

    Basically I need to move on in the package for the other tasks without failing the whole thing.

    Any help would be appreciated.

    Thanks in advance

  • November 30, 2011 at 9:44 am

    #1414789

    You could try using an Execute SQL Task, setting the Result Set to a Single Row/Full Result Set, then setting that to a variable. This way it would either return something or not - Then on the join you create to the Data Flow task you can change the Precedence Constraint to be "Expression and Constraint". You could add simple code to determine if the variable has something in it or not...if it does it will hit the next step, otherwise it will ignore it.

    You could also set the ForceExecutionValue to true for that step in your package, but that might be a little harsh as it will ALWAYS move on even when the failure is legit...

    What types of things have you tried?

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • November 30, 2011 at 10:02 am

    #1414808

    Hi, thanks for the reply.

    I was able to fix the issue using conditional split. I've checked if one my columns was not null (meaning I do have records to process) and moving from that point on.

    Appreciate your time.

  • November 30, 2011 at 10:07 am

    #1414813

    Cool! Glad you got it wokring. Wouldn't it be GREAT it this site had a Resolved button for posts???

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

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

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