Tag : SSIS

SSIS – Error 0xC020200E – Cannot open the datafile “PathToFile”

This error presented itself when attempting to run an SSIS package that needed to write to a file share across the network to another server. The package worked when executed using my local account from Visual Studio but not when invoked from a stored procedure or via SQL Server Agent. A fully qualified UNC path was being used. The Agent job Owner…