I have a SSIS package that picks up csv files from a shared folder on daily basis and load the data into sql database.
When I execute the package in Bids environment everythin works fine. But, when I try setting up an schedule for the package, then the job fails.
I assume my SQL account doesnt have permissions to access the folder. how am I suppose to ensure that the sql account has required permissions to access the folder?