I've created one SSIS package. In which I'm transferring data from excel file to SQL Server. Source file i.e excel file is located in a shared folder that is password protected. When I execute this package in SSDT, it works absolutely correct. However, after deployment, when I execute this same package, it shows the following error:
Can anyone help me out how I can access excel file from a shared folder aftre deployment? What configurations I need to perform to get this done?