Hi, I have a number of flows in a package that are reading to check for changes in data and then outputing those changes to flat files. If there are no changes, that is, I read no rows in my oledb source, an empty flat file is created. Consequently,
the file is sent and the destination is empty for the next run time.
This is not really the worst thing in the world, but I would rather not FTP off empty flat files, if only for the sake of efficiency. Is there a way to prevent the creation of the flat file if no rows are going to be written?
View Complete Post