question

Raj More avatar image
Raj More 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?
ssissql-server-2008-r2oracle
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Daniel Ross avatar image
Daniel Ross answered
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?
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Raunak Jhawar avatar image
Raunak Jhawar answered
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.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

How do you use IO library to count from an XML file?
0 Likes 0 ·
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
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.