SSIS - Cannot Open the data file.

• EwanAC

  SSChasing Mays

  Points: 656

  More actions

  January 13, 2017 at 5:48 am

  #333821

  We have developed an SSIS package that opens a source from our network drive, of which the file permissions are authorised for the user.

  Initially we have created a package and have deployed it to an Integration Service Catalog. From there we scheduled the package as a job and it worked without an issue.

  Then we want to make it an automated process with a variable destination filename - we used the sql server command prompt to execute the package. 
  This passed in the parameters for the package to use.

  However now when the package runs we get the error message - DataFlow Task 1:Error: Cannot open the datafile "xxxx"
   second message - failed the pre-execute phase and returned error code 0xC020200E.

  We are using a new user with permissions to access the files, could there be anything else we are missing which would mean that sql server wont open the file?
  We believe it is permission related, Can anyone share some ideas?

  Thanks in advance.