SQLTeam.com | Weblogs | Forums

SSIS error: cannot open the data file and encountered the pre-execute phase and returned error code 0xC020200E

this question has been asked quite a lot of times here and I could not solve with the given answers.Could anyone help me. I am trying to run the SSIS package for the csv file and it gives me the errors as below. [FF_SRC - I-A[17]] Error: Cannot open the datafile "".

[SSIS.Pipeline] Error: FF_SRC - I-A failed the pre-execute phase and returned error code 0xC020200E.

I have copied this package from an existing one and edited it. The existing package could be run without error. But this package seems to have error in picking up the file. Could anyone help?

It could be a number of things. Does the file exist? Does the account you are running have access to the folder/file? Is the folder/file a variable in the SSIS package? If so, do you have DelayValidation set to True?