Excel privary levels

• V

  Valued Member

  Points: 70

  More actions

  September 19, 2021 at 10:31 am

  #3930928

  There are three Excel privacy levels: Private, Organizational, Public. When Excel's privacy level is Public I can get data using Integration Services -> Data Flow -> Excel task.

  When Excel's privacy levels is Organizational or Private, I can't get data. When I open Excel task, Excel's sheet's cannot be seen. It looks like empty file.

  All I'm doing locally. I can open Excel file and see all data, change privacy level.

  How to fix it?

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  September 20, 2021 at 11:10 am

  #3931104

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.