I have an SSIS package that exports data to delimited text files. I am
experiencing a problem that (several times a week) the file that is created
only contains the column delimeters (no data). It is also notable that there
is a row of delimited columns (no data) for each row of data that is
available for exporting (i.e. if there were 10 rows available, then I will
see 10 rows of column delimiters). The SSIS package reads an input file,
imports the data into a table, then creates 1 or more export files (the data
is site specific). When the problem occurs, it seems to only affect one of
the export files, not always but I cannot find a pattern as to what, when or
why it is happening. If I re-process the input file, then the export files
are created without issue.