I am somewhat new to SSIS, and working on a package which combines combines the data from 3 different sql queries using Union All, then checks the Row Count and decides whether to create the destination flat file or now.
My intention is to skip the creation of a blank file in case if no rows exist in the result set, and create it only if data rows are passed.
My current data flow sequence is as follows:
3* OLE Db source
I am able to get the data past the RowCount component but unable to use conditional split transform to split the output based on Rowcount, since it does not let any data through based on the value of the Rowcount variable.
I have seen some scenarios that use Script component to get the split done, but not sure how to compare the variable value, and if any input columns need to be passed as inputs.
Can someone please point me on how to get this done?
View Complete Post