SQL Server Performance

can not open file

Discussion in 'SQL Server 2005 Integration Services' started by fmardani, Jul 26, 2007.

  1. fmardani New Member

    Hello,

    Using a foreach loop which contains dataflow. Inside dataflow there is a flatfile source.

    The following error is produced inthe flat file source.



    Error: 0xC020200E at Data Flow Task, Flat File Source [446]: Cannot open the datafile "EqRonnieHK".

    Error: 0xC004701A at Data Flow Task, DTS.Pipeline: component "Flat File Source" (446) failed the pre-execute phase and returned error code 0xC020200E.



    Please note, the file does indeed exist



    Thanks
  2. satya Moderator

    Have you checked the privileges for the user on that share or drive where this is located?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    @http://www.askasqlguru.com/

    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. dineshasanka Moderator

    When you are getting this error. Do you get this error when it is running fro, Visual studio or from SQL serve agent.
    Where is this file is it in a remote machine. If your file is in remote machine and you have given UNC path, make sure that your sql agent user account has permission to the folder.

Share This Page