I'm using Automation Designer to run a query and then export the data as an Excel file. I've used the "If..Then..Else" to start the run.
My first step is to connect to the server. This is working fine with no problems. In the next step, it's attempting to run the query via the "Export Dataset" which I've named "PDA Update". The properties look like this:
Using this method, this always fails. I can run it manually with no issues, But if it is scheduled at a specific time, it fails. The error message says:
1/7/2016 6:15:11 AM: PDA Update (Export Dataset) started.
1/7/2016 6:15:16 AM: ERROR: The path %1 could not be found
1/7/2016 6:15:16 AM: PDA Update (Export Dataset) finished.
Can you help me determine why this is failing?
For the record, I have other automated processes that are running with no issues. The only difference is these are using the "Execute Script" method. Any thoughts as to why it is failing?
In advance, thanks for your help.