SSIS - Cant open my file on execute

• EwanAC

  SSChasing Mays

  Points: 656

  More actions

  January 13, 2017 at 8:32 am

  #333822

  I have tried to execute a SSIS package and the following is the result:

  DataFlow Task 1:Error: Cannot open the datafile".OUT file".

  DataFlow Task 1:Error: Source - (.OUT file) failed the pre-execute phase and returned error code 0xC020200E.

  Can someone suggest why it inst loading the file, it is stored on a shared network but the user has permissions to read the file?
  

• jamiros

  SSC Journeyman

  Points: 79

  More actions

  January 16, 2017 at 1:08 pm

  #1923048

  Have you checked permissions on the SQL Agent user? Also, maybe you need to do a Proxy to give access.
  I had a similar error and this solved the issue.
  My user had access but the SSIS user that executes the packages didn't.