I am getting following error when package is executed from BIDS:
Error: 0xC002F304 at File System Task, File System Task: An error occurred with the following error message: "Could not find file 'E:\Import\'.".
Error received through send mail task:
Error code: -1073548540
Error description: An error occurred with the following error message: "Could not find file 'E:\Import\'.".
1. Created an SSIS package to load .txt and .csv files, perform insert/update/delete operations
2. Rename files before loading new data. (fails here)
SQL Server Version: SQL Server 2008 R2 SP2 (64-bit)
OS: Windows Server 2008 R2 Standard SP1 (64-bit)
Created BIDS project on server (logged in with my domain account)
Also gave full permissions (SQL server account, SQL agent account, my domain account) on parent folder containing SSIS project and export folder.
Tried Executing package from BIDS, File system and SQL Server (after importing)
Please let me know where am I going wrong.
Verified file task mentioned on :
PS: BIDS project created in user profile and executing from same (this was failing), so moved to server drive and changed all paths accordingly (still failing).
Same works successfully on my laptop.
Thanks in advance.
Any suggestions are very much appreciated.