Post reply

SSIS - Cant open my file on execute

  • 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?

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply