Home Forums SQL Server 2005 SQL Server 2005 Integration Services IS IT POSSIBLE ?--NOT to CREATE Flat File If it is empty? RE: IS IT POSSIBLE ?--NOT to CREATE Flat File If it is empty?
Chuck Rivel
SSCrazy
Points: 2991
More actions
August 11, 2008 at 9:42 am
#856182
one approach, there is a row count data flow task that will add the row count value to a variable for your dataset and you can then perform another conditional split on that value being greater than 0 to hook into the flat file output path.
hth