I am reading data from an XML file, going through some transformations and then putting into an Oracle database.I do not want to execute the whole process if the XML file does not contain data. My question is: How do I test if the XML file has data and branch all in the same workflow?
asked Oct 04, 2010 at 02:54 PM in Default
you can't do expression constraint's in a workflow, it is something that i would like to see though, for example if you have other datasources that you read from, but if the MAIN source, in this case the XML source doesn't have any rows, then the dataflow will not read from the other sources.To do what you want you will have to read the xml file. you could just create a simple dataflow that has a rowcount transform and after that dataflow, you could put a ExpressionAndConstraint constraint between the data flows, that only runs the second data flow when there is a positive rowcount variable?
answered Oct 04, 2010 at 05:15 PM