Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Andy Leonard SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers RE: SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers

  • March 12, 2011 at 11:24 am

    #1298022

    ianc-1096396 (9/8/2010)

    Hi, I cant find the article. Would like to read it.

    Mean time, maybe someone can help. I am getting a result set from a query. into an object variable. I need to use it in a conditional expression. if the object has data, continue. If it NULL, end the job.

    objects cannot be used in an expression. Is there another way?

    One way was to put a SQL statement before this section that returned a COUNT, and then use that in the precedence contraint expression. But I'd rather not.

    Can it be done using the object variable?

    cheers

    Ian

    I have the same basic question. How can I determine if the object variable contains no records after my execute sql task so I can end the package, throw an error, etc.

    Great article Andy.