hi all please see attached image. I'm trying to add a precedence constraint to check to see if any emails are found or not. If emails are found, carry on, if not check sftp file location (we can receive files by both email and sftp). ISNULL does not work with object data type so how do i get around this??? Thanks!
I'm using cozyroc receive email task which outputs a result variable as object
ISNULL( @[User::MailList] ) if true check folder location if false carry on with exchange tasks...
hmm... image upload isn't working...
- Edited by jhowe1 Thursday, July 04, 2013 3:46 PM edit
You cannot use object variable in precedence constraint. You need to iterate through the object variable and save the iindividual value in a string variable. Then use string variable in precedence constraint
Nitesh Rai- Please mark the post as answered if it answers your question
The easiest way would probably be to use a script task. This excellent blog post explains how:
Read a DataSet From Variable In a Script Task
Load the object variable in a datatable and do a simple count on this table. (use the Rows property)
- Proposed as answer by V Karthik Friday, July 05, 2013 8:48 AM