asked
decision making in SSIS Data Flow
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?
Hi Raj, 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?
rowcount is a good option, incase you wish to implement a script task you may use the IO libraries to read the fle and check the rowcount...it tends to ofer a similar functionality but you may wish to customize the custom component to suit you needs further and route the package flow accordingly.
Step 1: for every line read in the file increment a variable say count by 1 Step 2: if count>1 then process the package ahead else take the alternate
