Configuring Excel Power Refresh for SQL Agent Jobs

Configuring Excel Power Refresh for SQL Agent Jobs

Parent Previous Next

Configuring Excel Power Refresh for SQL Agent Jobs

Excel Power Refresh within a SQL Agent Job must be done by using a proxy account. Please use the following steps prior to configuring your SQL Agent Job:

1.  Create a credential based on your login (found within the Security folder in SSMS):

2.  Create a proxy account based on the previously created credential. Select the SSIS Package Integration Services Package subsystem:

3.  Set the job step to run as the proxy account:

4.  Start the job.

5.  If you receive the following error: "Code: 0x00000000     Source: TF Excel Power Refresh Task ExecuteTask Failed:     Description: Microsoft Excel cannot access the file <path>.xlsx'. There are several possible reasons:    ? The file name or path does not exist.  ? The file is being used by another program.  ? The workbook you are trying to save has the same name as a currently open workbook.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  1:28:39 PM  Finished: 1:28:44 PM  Elapsed:  4.735 seconds.  The package execution failed.  The step failed."

This issue can be resolved by adding a Desktop folder to the following directories:



6.  Restart the job.