Recently I had copied a excel file for analysis
from SFTP site to development server from my account and asked my team mate to
analyze it, by loading it into table.
He logged in to the server and used a simple data
flow task in SSIS with source as Excel to load the data. When he was connecting
excel using excel connection manager, he had a weird error.
He was unsure of why he was getting the error when
selecting the sheet names. Then when reported, we quickly got into the possible
reason of security.
As I copied the file from SFTP to Development
machine using my account, it had limited the access to other users. When he was
trying to load, he was facing the error because it was a read-only file for
him.
Soon I granted full permission to him on excel
security and it worked for him.
There are various different solution on internet
but initially none worked for us when we were trying to resolve. Hope this
solution would help someone!!
Comments
Post a Comment