question

AnudeepPabbathi-1969 avatar image
0 Votes"
AnudeepPabbathi-1969 asked AnudeepPabbathi-1969 commented

Excel Refresh in office 365

Hi All,

I have developed a package with Excel Refresh using C# code and it is working fine in dev server (has MS office 2013). Now i have moved the same package to Prod server which has Office 365 and Excel refresh is not happening and also not throwing any error.

Could you please help me on this.

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
1 Vote"
ZoeHui-MSFT answered AnudeepPabbathi-1969 commented

Hi @AnudeepPabbathi-1969,

May I know the version of your Visual Studio?

Also please help check the excel file is not read-only.

Found an article about Refresh Excel in SSIS, hope it could give you some idea.

https://www.mssqltips.com/sqlservertip/5946/refresh-excel-pivot-tables-automatically-using-ssis-script-task/

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October


· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I'm using sql server data tools 2015.
File is not in the read only format.

0 Votes 0 ·
ZoeHui-MSFT avatar image ZoeHui-MSFT AnudeepPabbathi-1969 ·

Could you please share the C# code with us, also the screenshot of the data flow is welcome

0 Votes 0 ·

Hi

I have seen the issue is not with C# code, because the issue is with Task scheduler.
This is the code i have used.

https://social.msdn.microsoft.com/Forums/vstudio/en-US/8bce17fb-eacd-4df3-8c10-bf8ae8a93c55/c-code-to-refresh-excel-data?forum=csharpgeneral

I'm calling the package with help of batch file in Task scheduler, when i logged to the server the excel is refreshing, but when i log-off from server the refresh is not happening.

I guess there is some configurations settings need to be update.

1 Vote 1 ·