Pages

Wednesday, February 25, 2015

Flat File Destination failed the pre-execute phase and returned error code 0xC020200E.

On SQL Server 2012 (or newer), when you are running a SSIS package (which accesses a network share), you can retrieve the following error message:

Flat File Destination failed the pre-execute phase and returned error code 0xC020200E.
and
Cannot open the datafile "\\<remoteserver>\<remotefile>"