I am trying to read a csv range from a sharepoint file with integration service activity, the account has access, the parameters are correct but i get this error
The caller doesn’t have permission to perform the action.
Probably. You can’t Read Range on a CSV. Although you may also have a permissions issue preventing the activity from even getting far enough to realize it isn’t an Excel file.
There are many posts on reading CSV from Sharepoint: