I agree with you. But I am not sure how can I set permission on my local package. The local package consists of source data as the external excel file and destination is the sql server database. Nowhere in package am I adviced to enter my username and pwd (set permission) to access the mapped drive.
As you may have known by now, I am a novice in SQL server, so any help may be a great one for me.