The Data Flow task is simple enough. It takes the results from a stored procedure, and pumps the data to a flat file using pipe's as delimeters for the data columns. For some reason, and only in select occurences, the file will get popoulated with bad/blank data.
For example, the top portion of the file has the data set as;
and this will continue throughout until it gets to something like this;
When the stored proc is run from Query Analyzer there are no issues, and I have been unable to replicate the behavior when running the package with the same data set.
Another piece of information which might be helpful, is that there are 2 of these packages that run as scheduled jobs, that pull similar data elements - not exactly the same - that are scheduled at the same time. If it was locking on the data wouldn't we expect to see this everytime since the schedule remains the same?
I feel like it is in the writing to the file that is causing the issue and not the SQL itself since it runs fine without error outside of the packages.
Any help would be greatly appreciated.