I just modified an existing automation script in TDP3.7 - there is a select file task that creates a new Excel file and an email activity. I added a second select to file activity and created a master Excel file with 2 tabs. I am exporting each result set from the 2 queries to a separate tab. I have many scripts just like this set up, but today all of a sudden I get this error:
Export_1 - ‘xr2’ is an undeclared prefix. Line 1, position 403.
I looked in the XML and I don’t see “xr2” anywhere. I set the script up again to send each query result to a new file and it worked fine. I’m not sure why this error popped up. I can send the automation script tomorrow.