Error Message:
[Flat File Source [1]] Error: Cannot open the datafile "D:\Taks\LookUpSource.txt".
[SSIS.Pipeline] Error: component "Flat File Source" (1) failed the pre-execute phase and returned error code 0xC020200E.
Solution:
Folder access permissions check:
[Flat File Source [1]] Error: Cannot open the datafile "D:\Taks\LookUpSource.txt".
[SSIS.Pipeline] Error: component "Flat File Source" (1) failed the pre-execute phase and returned error code 0xC020200E.
Solution:
- Check the file path availability
- Check the file name and extension.
- Verify the folder (File located folder) access permissions.
Folder access permissions check:
- Select required folder.
- Right click and select properties
- Go to 'Security' tab.
- Select the user.
- Verify the read and write permissions.
Well, this is not enough. Sometimes this error pops up even when the account has full permissions on the folder. I've found that sometimes one of the two approaches helps: (1) Add the account under which the SSIS package runs to Power Users on the destination server. (2) Grant NETWORK SERVICE full control on the folder into which to write the file. I know it does look like it makes no sense but it does sometimes help.
ReplyDeleteThank you so- much! I was able to get it to work with option (2) Awesome...
DeleteHi,
ReplyDeleteI have give read and write permission. But still not working. What else to do?
Thanks.