I have several Automation files with multiple Export Wizard activities that are supposed to export the data into a macro enabled workbook. Each activity is to export its data into a different worksheet within the same workbook. I recently upgraded to 5.1 and now when I run a majority of the Automation files they don't export. I've compared the log files for one of the files that still works against the others and cannot pinpoint the issue.
As a test I created an Automation with one Export Wizard activity, and included a SQL I knew had results. When the automation ran it exported 0 rows. So I added a "Select to File" activity and directed it's output to a new worksheet within the same Workbook. It has the exact same SQL as the Export Wizard activity. It exported results but the Export Wizard still did not.
Any help would be greatly appreciated.